A. Kretschmer wrote:
> In response to Alexander Farber :
> > And identifiers means column names (eventually containing whitespace)?
>
> Right.
>
> test=# select 'foo' as "my new column";
> my new column
> ---------------
> foo
> (1 row)
And double-quotes preserve case:
test=> select 'foo' as Mine;
mine
------
foo
(1 row)
test=> select 'foo' as "Mine"; <-- double-quotes
Mine <--
------
foo
(1 row)
--
Bruce Momjian <br...@momjian.us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ None of us is going to be here forever. +
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
