6 Replies Latest reply on Jan 27, 2015 10:39 PM by George Geo

    Getting write access to execute queries (changing Timezone) on PostGRE SQL of Tableau server

    George Geo

      Dear All,

       

      The default time zone of "workgroup"  DB in PostGRE SQL is UTC. How can we set this to PST timezone?

       

      We could get the default timezone from executing query SELECT * FROM pg_timezone_names  where lower(name) like '%pst%'

      To change the timezone, query is ALTER DATABASE workgroup SET timezone TO ‘PST8PDT';

       

      But the alter query is not working as only read only access is available. How to execute this query and change the timezone?

      In short, how to get write access to execute queries on PostGRE SQL of Tableau server.

       

      Any help is highly appreciated.