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
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