Logging in psql via command prompt
Psql is the interactive terminal for working with Postgres. Theres an abundance of flags available […]
Introduction of PostgreSQL
Listing all databases in postgresql
\list lists all databases \dt lists all tables in the current database Sample of \listwill […]
PostgreSQL – SELECT Database
If you want to list all databases please use After listing all the databases we […]
Listing all tables in postgresql
After listing all the databases, if we require a list of all tables that are […]
Connecting to postgres database with username concurrently
You can select your database from command prompt itself at the time when you login […]
Exporting data of postgresql database with pg_dump
pg_dump — extract a PostgreSQL database into a script file or other archive file. Example […]
Importing data of postgresql database with psql
psql is a terminal-based front-end to PostgreSQL. It enables you to type in queries interactively, […]
Select records from dates range in postgresql
We can simply use < (less than) and > (greater than) operators to find out […]