{"id":824,"date":"2021-11-21T06:25:37","date_gmt":"2021-11-21T00:25:37","guid":{"rendered":"https:\/\/mellowhost.com\/blog\/?p=824"},"modified":"2021-11-21T06:31:59","modified_gmt":"2021-11-21T00:31:59","slug":"how-to-set-timezone-in-postgres-databases","status":"publish","type":"post","link":"https:\/\/mellowhost.com\/blog\/how-to-set-timezone-in-postgres-databases.html","title":{"rendered":"How to Set Timezone in Postgres Databases"},"content":{"rendered":"\n<p><strong>Question: How to Set Timezone in Postgres Databases<\/strong><\/p>\n\n\n\n<p><strong>Answer<\/strong><\/p>\n\n\n\n<p>Postgres allows you to set a timezone per database. To view the list of available timezones, you may use the following query from psql:<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">select * from pg_timezone_names;<\/pre>\n\n\n\n<p>To set a timezone for say a database called &#8216;inventory_report&#8217;, you may use the following query:<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">alter database inventory_report set timezone to 'Asia\/Dhaka';<\/pre>\n\n\n\n<p><strong>Tips:<\/strong><\/p>\n\n\n\n<p>To List Postgres Databases, you may use the following command from psql:<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">\\l<\/pre>\n\n\n\n<p>To List Postgres Tables in a Database:<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">Connect to the database first:\n\n\\c my_prod\n\nNow, list:\n\n\\dt<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>Question: How to Set Timezone in Postgres Databases Answer Postgres allows you to set a timezone per database. To view the list of available timezones, you may use the following query from psql: To set a timezone for say a database called &#8216;inventory_report&#8217;, you may use the following query: Tips: To List Postgres Databases, you &hellip; <a href=\"https:\/\/mellowhost.com\/blog\/how-to-set-timezone-in-postgres-databases.html\" class=\"more-link\">Continue reading<span class=\"screen-reader-text\"> &#8220;How to Set Timezone in Postgres Databases&#8221;<\/span><\/a><\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[412,523],"tags":[414,580,232],"_links":{"self":[{"href":"https:\/\/mellowhost.com\/blog\/wp-json\/wp\/v2\/posts\/824"}],"collection":[{"href":"https:\/\/mellowhost.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/mellowhost.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/mellowhost.com\/blog\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/mellowhost.com\/blog\/wp-json\/wp\/v2\/comments?post=824"}],"version-history":[{"count":3,"href":"https:\/\/mellowhost.com\/blog\/wp-json\/wp\/v2\/posts\/824\/revisions"}],"predecessor-version":[{"id":827,"href":"https:\/\/mellowhost.com\/blog\/wp-json\/wp\/v2\/posts\/824\/revisions\/827"}],"wp:attachment":[{"href":"https:\/\/mellowhost.com\/blog\/wp-json\/wp\/v2\/media?parent=824"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/mellowhost.com\/blog\/wp-json\/wp\/v2\/categories?post=824"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/mellowhost.com\/blog\/wp-json\/wp\/v2\/tags?post=824"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}