kubada

ALTER TABLE {TABLE} ALTER COLUMN {COLUMN} TYPE TIMESTAMP WITHOUT TIME zone 
USING ("{column}"::text::timestamptz);

pg_dump --dbname=postgresql://USER:PASS@127.0.0.1:5432/DB > backup_name

CREATE TABLE {TABLE} (
	"id" SERIAL PRIMARY KEY,
	lalala
);

ALTER TABLE {TABLE}
ADD COLUMN id SERIAL PRIMARY KEY;

SELECT * FROM {TABLE} WHERE DATE > CURRENT_DATE - INTERVAL '30' DAY