Обсуждение: BUG #1364: using field names or table names with blanks

The following bug has been logged online:

Bug reference:      1364
Logged by:          Pit Mueller
Email address:      fmi-soft@gmx.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

"Pit Mueller" <fmi-soft@gmx.de> writes:
> 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]

One man's "elegant" is another's "ugly and nonstandard".

> PostgreSQL 8.0 should support this notation too.

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