Thank you, Gabriele. Now I realize "context sensitive" nature of field separator. Regards, Tena Sakai tsakai@xxxxxxxxxxxxxx On 5/30/10 1:37 AM, "Gabriele Bartolini" <gabriele.bartolini@xxxxxxxxxxxxxx> wrote: > Tena Sakai ha scritto: >> Can somebody please tell me what ³|² is called in my example above? >> And is it possible to change it from ³|² to something else for >> display purpose? > The field separatore in psql is used only when the format is "unaligned" > (which does not happen to be default). > > In order for it to be effective, you need to type in psql: > > \pset format unaligned > \pset fieldsep '\t' > > This will give you an output with columns that are separated by tab. > > However, I suggest that you look at the documentation for more options > and ways to achive the same results: > http://www.postgresql.org/docs/current/static/app-psql.html > > Cheers, > Gabriele -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
