Hi Greg, My apologies. I hadn't realized that -At was a combination of -A and -t. Rather, I kept thinking that t as argument to -A.
Regards, Tena Sakai tsa...@gallo.ucsf.edu On 6/1/10 11:02 PM, "Greg Smith" <g...@2ndquadrant.com> wrote: > Tena Sakai wrote: >> 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' >>>> > > You had -t in your original to turn off the display of column names and > the counts at the end, and -A is the shortcut for what you had as "-P > 'format=unaligned'". I throw "-At" into almost every use of psql from a > bash script I do, that's the usual combination that gets the basic > format to be right; then tweak things like the field separator afterwards. -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
