Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- #!/bin/bash
- # remove OID from all tables in listed databases
- # before execute: sudo su postgres
- echo "Start removing OIDs";
- for db in `psql -qAt -c "SELECT datname FROM pg_database WHERE datname != 'postgres' AND datallowconn = true ORDER BY datname;" postgres` ; do
- DATABASE_NAME="$db";
- echo "==============================";
- echo $DATABASE_NAME;
- for tbl in `psql -qAt -c "SELECT schemaname || '.' || tablename FROM pg_tables WHERE schemaname <> 'pg_catalog' AND schemaname <> 'information_schema';" $DATABASE_NAME` ; do
- psql -c "ALTER TABLE $tbl SET WITHOUT OIDS" $DATABASE_NAME ;
- done
- done
- echo "...done...";
Add Comment
Please, Sign In to add comment