PostgreSQL and time zones

If you do not feel anything special when someone says “timezones” then you can consider yourself to be lucky. If your application runs only in your local time zone a you never ever need to convert date/time between timezones then you are really lucky. But...

Find database creation date

We cannot find it directly but we can check attributes of directories which contain data files of each database. In PostgreSQL you can try this query: with mydir as (select setting||'/base' as _dir from pg_settings where name = 'data_directory'), mydbs as (select oid...