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,
the selection statement is very sophisticated statements to PostgreSQL
regarding performance, so use the SELECT statements with accuracy. PostgreSQL selection details are deployed to obtain
data from the database table, which is returning the data in the form of the
results table. These result tables are called result-sets.
The 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;
|