Category "postgresql-9.3"

Postgres equivalent for Oracle's DBA_FREE_SPACE and DBA_DATA_FILES

This is the sql query. I need to convert into postgres query SELECT a.tablespace_name, a.maxbytes, a.mbytes, (a.maxbytes - a.mbytes),

Rounding time to nearest hourly quarter in postgresql

I have timestamp column as: "2017-02-14 05:06:34" "2017-01-17 13:55:44" "2017-01-17 14:06:14" "2017-01-17 22:40:14" "2017-01-18 14:23:43" and I want to round