Home > mailing lists

Field Alias Alternative - Mailing list pgsql-sql

From	Bart Degryse
Subject	Field Alias Alternative
Date	April 29, 2008 07:20:59
Msg-id	4816E863.A3DD.0030.0@indicator.be Whole thread Raw
List	pgsql-sql

Is there another way to quote a field alias (containing spaces) than with double quotes?

This works:

SELECT actions.addresstypes.addresstype AS "Address Type" FROM actions.addresstypes

I would like something like this

SELECT actions.addresstypes.addresstype AS [Address Type] FROM actions.addresstypes

Is that possible?

Thanks for any ideas.

From: "Scott Marlowe"
Date: 29 April 2008, 03:31:28
Subject: Re: Truncate table at a certain size.

From: venkat
Date: 29 April 2008, 11:10:36
Subject: Reg:-How to make relationship more one table in PgSQL