Hi,

In my project I changed all timestamp columns to timestamp with
time zone.

I am used to test a lot using psql. Now the display of a
timestamptz column takes up too much space. I would like to set
it to a shorter format.

Can this be done by setting a default psql output format somehow?

I know about views and to_char() and extract, but is there a psql
way of doing it?

/Str.

You could try making a view, in wich you convert the type of the
timestamptz columno with timestamp only.

El 31/12/2011 12:40, M. Strobel escribió: