Hands-on task
PostgreSQL: INSERT and SELECT
In the shop database there is an empty table products(id, name, price). Insert three items: (1,'pen',50), (2,'lamp',150), (3,'desk',300). Then select the names of items more expensive than 100, alphabetically, and write them into /root/expensive.txt — one name per line, without the table header.
- postgresql
- insert
- select
- where
- order by