PostgreSQL - Get the serial ID of a newly created record
When you assign an Id to an inserted record things are great! When PostgreSQL assigns the Id, things get a little complex, especially if you want to immediately...
Postgres - Get the current time in milliseconds
To get the current time in milliseconds you can use the following:
Postgres - Multiple attempts to get current time return the same time value
I was trying to profile a store procedure that builds a temporary table before returning it to the caller. Multiple inserts, updates and transformations are performed on the...
Postgres - Return result set as JSON
This indispensable library has brought me a great deal of joy when it comes to json-ifying objects and primitives.
Postgres - Batch file to drop and recreate database
For the complete script scroll to the bottom of the page for the GitHub link Nothing kills the soul faster than repetition. Rather than repeating a task, it...
Postgres - Add/Create object if it doesn't already exist
The creation of database objects is fairly simple but the conditional creation of objects when they don’t exist can be a little convoluted with PostgreSQL.