Re: [GENERAL] Naming columns for SQL output ...

On Thu, Sep 23, 1999 at 08:12:34PM -0600, Aaron J. Seigo wrote:
> hi..
>
[ Jim Richards <grumpy@cyber4.org> wrote:  ]
> > How do I name a column in an SQL query. In Oracle I would use
> >
> >     select now() 'the time now';
> >
> > how is this done in PostgreSQL?
> >
> if i understand your question:
>
> select now() as 'the time now';

Always test your code ;-)

idas_demo=> select now() as 'the time now';
ERROR:  parser: parse error at or near "'"
idas_demo=> select now() as "the time now";
the time now
----------------------
1999-09-23 23:26:29-05
(1 row)

idas_demo=>

Hmm, seems since the string is a fieldname, it needs doublequotes.

Ross
--
Ross J. Reedstrom, Ph.D., <reedstrm@rice.edu>
NSBRI Research Scientist/Programmer
Computer and Information Technology Institute
Rice University, 6100 S. Main St.,  Houston, TX 77005