"filippo" <[EMAIL PROTECTED]> writes:
> I'd like to have
> DD-MM-YYYY for my timestamp field.
The closest display format to that is 'SQL, DMY':
regression=# set datestyle = 'sql, dmy';
SET
regression=# select current_date;
date
------------
03/06/2006
(1 row)
See the discussion of datestyle values in
http://www.postgresql.org/docs/8.1/static/datatype-datetime.html#DATATYPE-DATETIME-OUTPUT
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
