Groups > comp.databases.postgresql > #290

default output format of timestamptz in psql

Path	csiph.com!x330-a1.tempe.blueboxinc.net!newsfeed.hal-mli.net!feeder3.hal-mli.net!newsfeed.hal-mli.net!feeder1.hal-mli.net!de-l.enfer-du-nord.net!feeder1.enfer-du-nord.net!fu-berlin.de!uni-berlin.de!not-for-mail
From	"M. Strobel" <sorry_no_mail_here@nowhere.dee>
Newsgroups	comp.databases.postgresql
Subject	default output format of timestamptz in psql
Date	Sat, 31 Dec 2011 12:40:57 +0100
Lines	15
Message-ID	<9m8am9Fl58U1@mid.uni-berlin.de> (permalink)
Mime-Version	1.0
Content-Type	text/plain; charset=UTF-8
Content-Transfer-Encoding	7bit
X-Trace	news.uni-berlin.de TwVz1UKuDRN6tS6hkjUJDgnUsSjQmP8ASVuN4PO6ZTiXUlGUs=
User-Agent	Mozilla/5.0 (X11; U; Linux x86_64; de; rv:1.9.2.24) Gecko/20111101 SUSE/3.1.16 Lightning/1.0b2 Thunderbird/3.1.16
Xref	x330-a1.tempe.blueboxinc.net comp.databases.postgresql:290

Show key headers only | View raw

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.

Back to comp.databases.postgresql | Previous | Next — Next in thread | Find similar | Unroll thread

Thread

default output format of timestamptz in psql "M. Strobel" <sorry_no_mail_here@nowhere.dee> - 2011-12-31 12:40 +0100
  Re: default output format of timestamptz in psql Marcos PPa PPe <marcos@asi2cotarelo.net> - 2012-02-10 09:56 +0100

csiph-web