The following bug has been logged online:

Bug reference: 1364
Logged by: Pit Mueller
Email address: fmi-soft (AT) gmx (DOT) de
PostgreSQL version: 8.0
Operating system: WINXP
Description: using field names or table names with blanks
Details:

MS SQL Server uses a quite elegant method for using field names and table
names:

select [field] from [table]
f.ex. select [my field] from [the big table]

PostgreSQL 8.0 should support this notation too.
Brackets are not supported at the moment -> the SQL parser notifies an
syntax error

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo (AT) postgresql (DOT) org

"Pit Mueller" <fmi-soft (AT) gmx (DOT) de> writes:
One man's "elegant" is another's "ugly and nonstandard".

Not likely. Use double quotes like the SQL standard tells you to:

select "my field" from "the big table"

One would hope that SQL Server takes this too, since they claim some
amount of spec compliance.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo (AT) postgresql (DOT) org