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(at)cyber4(dot)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(at)rice(dot)edu>
NSBRI Research Scientist/Programmer
Computer and Information Technology Institute
Rice University, 6100 S. Main St., Houston, TX 77005