Get time format in PostgreSQL
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