Received: from sss.sss.pgh.pa.us (sss.pgh.pa.us [206.210.65.6]) by hub.org (8.9.3/8.9.3) with ESMTP id TAA54931 for ; Tue, 4 May 1999 19:51:35 -0400 (EDT) (envelope-from tgl@sss.pgh.pa.us) Received: from sss.sss.pgh.pa.us (localhost [127.0.0.1]) by sss.sss.pgh.pa.us (8.9.1/8.9.1) with ESMTP id TAA01679; Tue, 4 May 1999 19:50:58 -0400 (EDT) To: "Ross J. Reedstrom" cc: "pgsql-sql@postgreSQL.org" Subject: Re: [SQL] How to find SQL Functions In-reply-to: Your message of Tue, 04 May 1999 13:06:56 -0500 <372F3740.C786A5CA@rice.edu> Date: Tue, 04 May 1999 19:50:58 -0400 Message-ID: <1677.925861858@sss.pgh.pa.us> From: Tom Lane "Ross J. Reedstrom" writes: > \df [optional function name glob] > (there are, of course, equivalent SQL statements, that do the same thing > as the above psql convienience functions, using the appropriate system > tables (pg_*), which would allow one to avoid files and grep. But for > learning, there's a catch-22, and I already knew how to use grep ;-) BTW, 6.5 psql has a new command-line switch option -E, which causes it to display the SQL statements that it issues to carry out special commands like \df. Makes a great learning tool when you want to see what the system tables contain. regards, tom lane