Deviopath › PostgreSQL

Rename the Columns

Easy · SELECT Basics

Instead of *, you can list just the columns you want, separated by commas. AS gives a column a new name in the result (an alias). The table itself does not change.

Return every product with two columns: name renamed to product and price renamed to unit_price.

Next: Value of the Stock