Alias containing space in SQL using firebird database

Question

I have an SQL statement and I would like to have an alias with a space. For example:

select name as User name from users;

I tried different syntaxes but it fails.

select name as "User name" from users;
select name as 'User name' from users;
select name as {User name} from users;
select name as [User name] from users;

database version: Firebird 2.5

Help me please

Are you running these statements directly from the command line? — Tim Biegeleisen
– Tim Biegeleisen, Commented Oct 9, 2017 at 11:43
If you were running this on dialect 3 from the command line, then you might have had an option to make this work: stackoverflow.com/questions/35574477/… — Tim Biegeleisen
– Tim Biegeleisen, Commented Oct 9, 2017 at 11:46
I think the easiest way out of this is to heed Gordon's warning and just avoid spaces. If you follow the link I pasted above, it appears that the 2.x dialog does not support double escaping, so you might be out of luck even if you wanted to do it. — Tim Biegeleisen
– Tim Biegeleisen, Commented Oct 9, 2017 at 12:28

Gordon Linoff · Accepted Answer · 2017-10-09 11:42:29Z

5

I would advise you to simply stop wanting the space -- it is a hassle to deal with delimited identifiers in any database.

But, as the documentation explains, Firebird does not necessarily support them:

Delimited identifiers are available in Dialect 3 only. For more details on dialects, see SQL Dialect.

answered Oct 9, 2017 at 11:42

Gordon Linoff

1.3m62 gold badges706 silver badges857 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Alias containing space in SQL using firebird database

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related