PostgreSQL SELECT statement is used to fetch the data from a database table, which returns data in the form of result table. These result tables are called result-sets.
Syntax:
SELECT column1, column2, columnN FROM table_name;
If you want to fetch all the fields available in the field then you can use the following syntax −
SELECT * FROM table_name;
The following is an example, which would fetch ID, Name and Salary fields of the customers available in CUSTOMERS table −
testdb=# SELECT ID, NAME, SALARY FROM COMPANY ;
On this page of the site you can watch the video online PostgreSQL - Tutorial 6 -- Select in with a duration of hours minute second in good quality, which was uploaded by the user txt2text 21 February 2020, share the link with friends and acquaintances, this video has already been watched 700 times on youtube and it was liked by 31 viewers. Enjoy your viewing!