Tom Many thanks. Suppose I now want to know if there are any user defined functions set up in my database? I was rather hoping I could do something simple like
\df to get a list of **user** defined functions rather as \dt gives me a list of my tables and not the complete list of all the system tables as well. Is there a way of achieving this? Hilary At 10:40 23/09/2005 -0400, you wrote: >Hilary Forbes <[EMAIL PROTECTED]> writes: >> How can I easily get to see the definition of a user defined function >> please? > >Look in pg_proc. > > regards, tom lane > >---------------------------(end of broadcast)--------------------------- >TIP 3: Have you checked our extensive FAQ? > > http://www.postgresql.org/docs/faq Hilary Forbes The DMR Information and Technology Group (www.dmr.co.uk) Direct tel 01689 889950 Fax 01689 860330 DMR is a UK registered trade mark of DMR Limited ********************************************************** ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster