Friday, April 17, 2026

What is an OS collation often referred to when dealing with PostgreSQL servers?

›
We have seen the following error in on of our postgres databases: WARNING: database "testdb" has a collation version mismatch DET...
Wednesday, April 15, 2026

Workaround for ORA-00942: table or view does not exist when executing GRANT on a table list

›
When executing dynamic SQL against a schema that has differenly named objects, you will run into the "ORA-00942: table or view does not...
Monday, March 23, 2026

Inter-database import and exports using Oracle data pump

›
To move an entire schema from one schema to another within the same Oracle database, there is no need to export data to disk and then reimp...
Wednesday, March 11, 2026

How to dump the entire schema's DDL into a file

›
pg_dump -d mydb \ --schema-only \ --no-owner \ --no-privileges \ -n myschema \ -f create_schema.sql The flag "--no-owner...

Some examples of how to use the function pg_partition_tree

›
From PostgreSQL 11, the fuction pg_partition_tree has been available Usage, in its simplest form: SELECT * FROM pg_partition_tree('ld...

Find active queries in PostgreSQL

›
SELECT pid, state, now() - query_start AS duration, left(query, 80) AS query FROM pg_stat_activity WHERE state != 'idle' AND usena...
Thursday, March 5, 2026

Identity columns vs free-standing sequences in PostgreSQL

›
Are the columns typically used in primary key columns, defined as IDENTITY columns, or as standalone columns with a default value generated...