Get time format in PostgreSQL If I want get Ubuntu system time, I have two options:

$ cat /etc/timezone
US/Eastern

$ date
Sun Sep 15 14:45:02 EDT 2013


How can I find out if PostgreSQL is using utc or a utc offset, such as US/Eastern?
You can use current_setting() function to get the TIMEZONE setting.

SELECT current_setting('TIMEZONE') TZ;


Sample output:


# SELECT  current_setting('TIMEZONE') TZ;
     tz     
------------
 US/Eastern
(1 row)



Here is SQLFiddle demo