st 23. 12. 2020 v 17:38 odesílatel Andreas Karlsson
napsal:
> On 12/23/20 7:18 AM, Pavel Stehule wrote:> I am playing with clipboard
> on Linux, and I found a way, how to redirect
> > psql output to clipboard via wl-copy or xclip and then to Libre Office.
> > Now it looks so best format is tsv
>
On 12/23/20 7:18 AM, Pavel Stehule wrote:> I am playing with clipboard
on Linux, and I found a way, how to redirect
psql output to clipboard via wl-copy or xclip and then to Libre Office.
Now it looks so best format is tsv
select * from pg_database \g (format=tsv) | wl-paste -t
application/x-l
st 23. 12. 2020 v 16:54 odesílatel Bruce Momjian napsal:
> On Wed, Dec 23, 2020 at 04:39:48PM +0100, Pavel Stehule wrote:
> >
> >
> > st 23. 12. 2020 v 16:24 odesílatel Tom Lane napsal:
> >
> > Bruce Momjian writes:
> > > On Wed, Dec 23, 2020 at 07:18:24AM +0100, Pavel Stehule wrote:
>
On 12/23/20 10:13 AM, Pavel Stehule wrote:
>
>
> After this second check, I think the new format is not necessary,
> because tsv in LO is not tsv, but it is cracked csv
>
>
I agree, I don't think this is a format we need to spent much time on.
If you set the quote to an unlikely character lik
On Wed, Dec 23, 2020 at 04:39:48PM +0100, Pavel Stehule wrote:
>
>
> st 23. 12. 2020 v 16:24 odesílatel Tom Lane napsal:
>
> Bruce Momjian writes:
> > On Wed, Dec 23, 2020 at 07:18:24AM +0100, Pavel Stehule wrote:
> >> Implementation of tsv format should not be hard.
> >> What
st 23. 12. 2020 v 16:24 odesílatel Tom Lane napsal:
> Bruce Momjian writes:
> > On Wed, Dec 23, 2020 at 07:18:24AM +0100, Pavel Stehule wrote:
> >> Implementation of tsv format should not be hard.
> >> What do you think about this?
>
> > How would you handle tabs in the data?
>
> The main proble
Bruce Momjian writes:
> On Wed, Dec 23, 2020 at 07:18:24AM +0100, Pavel Stehule wrote:
>> Implementation of tsv format should not be hard.
>> What do you think about this?
> How would you handle tabs in the data?
The main problem with csv is the severe lack of standardization
around what to do w
st 23. 12. 2020 v 15:21 odesílatel Bruce Momjian napsal:
> On Wed, Dec 23, 2020 at 07:18:24AM +0100, Pavel Stehule wrote:
> > Hi
> >
> > I am playing with clipboard on Linux, and I found a way, how to redirect
> psql
> > output to clipboard via wl-copy or xclip and then to Libre Office. Now
> it
On Wed, Dec 23, 2020 at 07:18:24AM +0100, Pavel Stehule wrote:
> Hi
>
> I am playing with clipboard on Linux, and I found a way, how to redirect psql
> output to clipboard via wl-copy or xclip and then to Libre Office. Now it
> looks
> so best format is tsv
>
> select * from pg_database \g (form