Re: psql questions: SQL, progname, copyright dates

On Mon, 2004-08-30 at 03:28, Greg Stark wrote:
> Robert Treat <xzilla@users.sourceforge.net> writes:
> 
> > OTOH I know that I sometimes use /df to look up built in functions that I 
> > don't exactly remember, so keeping a way to access the system functions is 
> > handy. 
> > 
> > Given a third hand I'd look for some way to do both... perhaps \df can show 
> > all functions and \df- can show only user created functions?
> 
> Well there's always \dtS and \dvS I don't see why typing \dfS is any harder.
> 
> It would be nice for this to be more visible in the documentation and the \?
> output though. I've only just found it after months of pulling hair out
> looking for something just like it.
> 

Wow you're not kidding. I've been using postgresql for I don't know how
many years and I don't think I'd ever noticed that before.  ISTM that we
can make \df return only user function and \dfS return the system
functions, and this would be consitant with how we handle other options.
Just make sure to reword \? out put to make it clear that adding S will
show system objects. 

Robert Treat
-- 
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL