PostgreSQL

PostgreSQL AS

Give columns and tables readable aliases.

Column aliases

SELECT name AS product_name,
       year AS release_year
FROM products;

Use AS to label an output column without changing the table. Table aliases make joins shorter and clearer.

SELECT p.name
FROM products AS p;