Skip to main content

Select Query in PostgreSQL

In this tutorial, you will learn how to query basic data using the original PostgreSQL SELECT selection statement.
SELECT keywords are most commonly used in PostgreSQL to fetch records from the table, selection statement is very sophisticated statements to PostgreSQL regarding performance so use the SELECT statements with accuracy. PostgreSQL selection details is deployed to obtain data from the database table, which is returning the data in the form of results table. These result tables are called result-sets.

Syntax for SELECT statements:


SELECT column1, column2, columnN FROM table_name;


Here, column 1, column 2 is the fields of ​​a table whose value you want to receive. If you want to access all the fields in the result set then you can apply the following syntax –

SELECT * FROM table_name;