Thread: UPDATE on Pgadmin III not honoring DATESTYLE

UPDATE on Pgadmin III not honoring DATESTYLE

From
Francisco Leovey
Date:
Update on this problem: it only happens if you use the  "view data" option.
On the SQL window if you do a "select * from table" the date fields show correctly according to the datestyle set on the host database


PostgreSQL version: 8.1.2
Operating system:   Linux
Description:        Pgadmin III not honoring DATESTYLE
Details:

By default in postgresql.conf the DATESTYLE is set to "SQL,European" and it works OK except for Pgadmin III.
When you ask for "view data" in Pgadmin III a date field shows yyyy-mm-dd instead of dd/mm/yyyy
Please tell me how to fix this
Thank you


Yahoo! Autos. Looking for a sweet ride? Get pricing, reviews, & more on new and used cars.