From: | Tena Sakai <tsakai(at)gallo(dot)ucsf(dot)edu> |
---|---|
To: | Greg Smith <greg(at)2ndquadrant(dot)com> |
Cc: | Gabriele Bartolini <gabriele(dot)bartolini(at)2ndQuadrant(dot)it>, "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: What is field separator? |
Date: | 2010-06-01 05:27:59 |
Message-ID: | C829E86F.AF42%tsakai@gallo.ucsf.edu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Many thanks, Greg!
I got it to work by emulating what you wrote.
But I think you meant -A, not -At below.
>> psql -c "select name,setting from pg_settings limit 1" -d postgres -At
>> -F $'\t'
Regards,
Tena Sakai
tsakai(at)gallo(dot)ucsf(dot)edu
On 5/31/10 8:07 PM, "Greg Smith" <greg(at)2ndquadrant(dot)com> wrote:
> Tena Sakai wrote:
>> $ echo "select marker, p, afreq from gallo.fbat_sdsdecode limit 10" | \
>>> psql -P 'format=unaligned' -P 'fieldsep=\t' -t -f - musket
>> What's denoted as \t is not a tab character. It is a two character
>> sequence backslash followd by a t. I have tried all other possibilities
>> such as \\t , "\t", etc that I can think of, but I cannot get an honest to
>> god tab character to appear as field separator.
>
> Yeah, that's a tough one. In bash you can use ANSI C quoting to pull
> this off:
>
> psql -c "select name,setting from pg_settings limit 1" -d postgres -At
> -F $'\t'
>
> See http://wiki.bash-hackers.org/syntax/quoting for more information.
> Portability to other shells I'm not sure about.
>
> Note that I did two other things a little differently than your example,
> as well as tightening up the abbreviations:
>
> -Putting the command in -c " " is just better all around than piping
> into psql using echo. It even works with multi-line input, i.e.:
>
> psql -c "
> select 1
> "
>
> -Explicitly specifying the database manually using -d makes what's
> happening easier to follow than expecting people to know the convention
> that the first non-option passed to psql is a database name.
From | Date | Subject | |
---|---|---|---|
Next Message | Tena Sakai | 2010-06-01 05:29:51 | Re: What is field separator? |
Previous Message | Alvaro Herrera | 2010-06-01 03:58:59 | Re: What is field separator? |