PostgreSQL Alias Statement

postgreSQL Aliases are used to give temporary names to tables and columns. If users want the name to be more readable than the Aliases used.The Aliases only gives temporary names does not change in the original database.Aliases are usually preferred when a query includes more than one table.

Aliases statement Syntax :

The syntax of the Aliases statement is −

Alias Column Syntax
--------------------
SELECT column-name AS alias-name
FROM table-name;
--------------------
--------------------
Alias Table Syntax
-------------------
SELECT column-name(s)
FROM table-name AS alias-name;

Aliases statement Example :

Consider the Customer table with the following records -

Alias for Columns Examples:- The following code is an example that will temporarily change the column name to "Name" :-

lfcdb=# SELECT CustomerName AS Name FROM Customer; 

The result for the respective postgreSQL query is as follows −

Alias for Tables Examples:- The following code is an example that will temporarily change the table name to C :-

lfcdb=# SELECT CustomerName FROM Customer AS C; 

The result for the respective postgreSQL query is as follows −

---

Visit :

---

Discussion