PSQL: Who Is The Current User
You can determine the current user of a psql session by selecting on the current_user
Recent Posts
PSQL: Use Argument Indexes
In Postgres, each of the arguments you specify in a select statement has a 1-based index tied to it. You can use these indexes in the order by and group by p...
PSQL: Use unlogged tables for caches
Using a Postgres table for caching? You might want to try making it unlogged.
PSQL: Types By Category
Postgres has many types, each of which fall into a particular category. These categories include Array, Boolean, String, Numeric, Composite, etc. Each of the...
PSQL: Truncate Tables With Dependents
If you have tables A and B where B has a foreign key referencing A, then trying to truncate A will result in something like this: