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 "tablename" (
	"id" SERIAL PRIMARY KEY,
	lalala
);

ALTER TABLE tablename
ADD COLUMN id SERIAL PRIMARY KEY;