> For the complete documentation index, see [llms.txt](https://dev7days.gitbook.io/dev7days/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://dev7days.gitbook.io/dev7days/postgres/column-alias.md).

# Column Alias

Describe about Alias command

Alias is a command that you can assign temporary name to the column \
\
**Illustrates the syntax of using a column alias:**

```sql
Select first_name, last_name as surname from customer
```

The **`AS`** keyword is optional so you can omit it like this

```sql
Select first_name, last_name surname from customer
```

In case that you would like the temporary name to have the space you can use double quoete

**example**

```sql
Select first_name || ' ' || last_name surname as "full name" from customer
```