-
Which version of PostgreSQL am I running?
You just got hired, asked to perform a health check on PostgreSQL servers and you don’t know exact version of PostgreSQL. TL;DR: SELECT VERSION(); or pg_config –version When we say version, there are two possibilities, client version and server version. Checking Client Version psql is our client on terminals, to check it’s version psql –version…
-
Show tables in PostgreSQL
How to show tables in PostgreSQL is a common question for beginners. In this article we will discuss showing tables in PostgreSQL. In PostgreSQL all information about DB objects stored under information_schema. You can use information_schema.tables table to list and show tables. A simple query to list all tables and schemas: If you want to…