-- Change owner of all tables of a given schema -- list all tables of a schema for tbl in `psql -qAt -c "select tablename from pg_tables where schemaname = 'prod';" sachi` ; do echo $tbl; done |
DBA's Home Page - A website for Oracle, Greenplum and PostgreSQL DBA's > Greenplum DBA Quick Reference >