change ,alter owner table postgres
danang setya pramanaSELECT 'ALTER TABLE ' || quote_ident(schemaname) || '.' || quote_ident(tablename) || ' OWNER TO nama_user_baru;' FROM pg_tables WHERE schemaname = 'public'; copy output ke psql kembali
Danang Setya Pramana - Working Memory
This is my working memory when i forgot some command and some code for my work
SELECT 'ALTER TABLE ' || quote_ident(schemaname) || '.' || quote_ident(tablename) || ' OWNER TO nama_user_baru;' FROM pg_tables WHERE schemaname = 'public'; copy output ke psql kembali