Postgres Pro
Downloads
Home   >   mailing lists

Thread: help with select * from functionname() ?

help with select * from functionname() ?

From
glenn
Date:
Hi All
I'd like to be able to issue the command

select * from functionname();

however it seems that the parser won't accept the () on the function
name. (I'm trying to model this on chapter 9 of the programmers guide).
Is anyone able to suggest to me what i might be doing wrong?
thanks
Glenn

Re: help with select * from functionname() ?

From
Tom Lane
Date:
glenn <vmstech@tpg.com.au> writes:
> I'd like to be able to issue the command
>    select * from functionname();
> however it seems that the parser won't accept the () on the function
> name. (I'm trying to model this on chapter 9 of the programmers guide).
> Is anyone able to suggest to me what i might be doing wrong?

Uh, using an old Postgres?  We support that syntax beginning in 7.3...

            regards, tom lane

\pset pager

From
"cristi"
Date:
I don't want to input the command "\pset pager" each time when I start the
psql.
How can I do that?

Re: \pset pager

From
Andrew McMillan
Date:
On Fri, 2003-02-21 at 19:04, cristi wrote:
> I don't want to input the command "\pset pager" each time when I start the
> psql.
> How can I do that?

From the manpage:

ENVIRONMENT
       HOME   Directory for initialization file (.psqlrc) and command
history file (.psql_history).


Regards,
                    Andrew.
--
---------------------------------------------------------------------
Andrew @ Catalyst .Net.NZ Ltd, PO Box 11-053, Manners St,  Wellington
WEB: http://catalyst.net.nz/         PHYS: Level 2, 150-154 Willis St
DDI: +64(4)916-7201     MOB: +64(21)635-694    OFFICE: +64(4)499-2267
           Survey for nothing with http://survey.net.nz/
---------------------------------------------------------------------