Re: Single quotes vs. double quotes when setting a pwd and other cmds - Mailing list pgsql-general

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  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + None of us is going to be here forever. +