Wednesday, August 31, 2022

Rename table in postgreSQL: syntax

›
Rename a table: alter table myschema.mytable rename to mytable_old; Change ownership for a table: alter table myschema.mytable owner to ...
Friday, August 26, 2022

How to generate insert statements for a table in PostgreSQL

›
Thanks to Carlos Becker for pointing out the following solution on how to generate insert statments for a table in PostgreSQL pg_dump myd...

How to find the oid for a table in PostgreSQL

›
Connected to the relevant database using the connection tool of your choice, execute the following to find the oid for a table: mydb # sel...
Thursday, August 25, 2022

Query to find schema size in PostgreSQL

›
SELECT pg_size_pretty(sum(pg_relation_size(quote_ident(schemaname) || '.' || quote_ident(tablename)))::bigint) FROM pg_tables WHE...
Wednesday, August 24, 2022

Does PostgreSQL support global indexes on partitioned tables?

›
PostgreSQL does not support Global Indexes, i.e indexes that spans all partitions in a partitioned table. The documentation states: Alth...
Tuesday, August 23, 2022

How to extract hostname withouth FQDN in a shell variable

›
Taken from https://stackoverflow.com/questions/36151206/hostname-variable-in-shell-script-not-fqdn and really useful: export HOST=${HOSTNA...
Friday, August 12, 2022

Workaround for ORA-65011 in an upgraded EBS database running multitenant

›
If you are converting a non-cdb EBS database to a pdb in a multitenant setup, and your non-cdb had a name that used lower case ("pdb1...