Select records from dates range in postgresql
We can simply use < (less than) and > (greater than) operators to find out records from specific tables in postgre. Example (select all records) Selecting records from range of dates Format is :...
Category: Introduction of PostgreSQL
Introduction of PostgreSQL
Importing data of postgresql database with psql
psql is a terminal-based front-end to PostgreSQL. It enables you to type in queries interactively, issue them to PostgreSQL, and see the query results. Alternatively, input can be from a file. In addition, it...
Exporting data of postgresql database with pg_dump
pg_dump — extract a PostgreSQL database into a script file or other archive file. Example after executing first line, the system only asks for password of the user and the dump file will be...
Connecting to postgres database with username concurrently
You can select your database from command prompt itself at the time when you login to your database. Example :
Listing all tables in postgresql
After listing all the databases, if we require a list of all tables that are present in database, we may use it as :
PostgreSQL – SELECT Database
If you want to list all databases please use After listing all the databases we have to select a working database. In order to do this we have to type a command as :...
Listing all databases in postgresql
\list lists all databases \dt lists all tables in the current database Sample of \listwill be displayed as :
Logging in psql via command prompt
Psql is the interactive terminal for working with Postgres. Theres an abundance of flags available for use when working with psql, but lets focus on some of the most important ones, then how to...