Get the physical disk size of a postgres db

SELECT pg_database.datname,
pg_size_pretty(pg_database_size(pg_database.datname)) AS size
FROM pg_database;

Handling DATEADD in Postgres

Here's a link that compares mssql's DATEADD function to an equivalent method in Postgres.


Essentially the following work:

d1.tran_dts + cast('-6 months' as interval), d1.tran_dts + cast('1 year' as interval)

select '2004-2-29'::date + cast('1 years' as interval)
select '2004-2-29'::date + cast('-3 months' as interval)
select '2004-2-29'::date + cast('2 days' as interval)

Your only security is your ability.

source unknown