Alias Column Name

Question

I am trying to run a basic select Query in PostgreSQL, but I am having trouble using the column alias. I tried to create the alias as randomfield As [Space In Name] but it gave an error of

Error: syntax error at or near "["
Line 2: randomfield As [Space In Name]

And I also tried to do the alias w/o the brackets but that presented an error as well. How do you alias with a space in Postgresql?

Select randomfield As [Space In Name]
From saledata

https://www.postgresql.org/docs/current/static/sql-syntax-lexical.html#sql-syntax-identifiers — a_horse_with_no_name, Oct 27 '17 at 05:48

score 5 · Accepted Answer · edited Oct 27 '17 at 05:48

5

Identifiers with special characters require double quotes in SQL:

SELECT randomfield AS "Space in Name" FROM saledata

edited Oct 27 '17 at 05:48

a_horse_with_no_name

69,148
13
135
173

answered Apr 21 '16 at 17:44

Jonathan Fite

7,306
1
17
26

Alias Column Name

1 Answers1