Received: from ece.rice.edu (ece.rice.edu [128.42.4.34]) by hub.org (8.9.3/8.9.3) with ESMTP id OAA00149 for ; Tue, 4 May 1999 14:06:58 -0400 (EDT) (envelope-from reedstrm@rice.edu) Received: from rice.edu (wallace.ece.rice.edu [128.42.12.154]) by ece.rice.edu (8.9.0/8.9.0) with ESMTP id NAA08412 for ; Tue, 4 May 1999 13:06:56 -0500 (CDT) Sender: reedstrm@ece.rice.edu Message-ID: <372F3740.C786A5CA@rice.edu> Date: Tue, 04 May 1999 13:06:56 -0500 From: "Ross J. Reedstrom" Organization: NSBRI X-Mailer: Mozilla 4.06 [en] (X11; U; Linux 2.2.3-ac3 i686) MIME-Version: 1.0 To: "pgsql-sql@postgreSQL.org" Subject: Re: [SQL] How to find SQL Functions References: <372F3212.5D4D05A3@nsi.edu> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit G. Anthony Reina wrote: > > I found in the on-line manuals a listing of the math, string, etc. > functions for PostgreSQL. However, I know that there are more than those > listed in the manual. > > Is there some PSQL command to list all of the functions that PostgreSQL > recognizes? > functions: \df [optional function name glob] operators (there are some weird ones): \do [opt glob] you may want to use \o filename to redirect output to a file, then you can use "grep" and such tools to find functs, etc. based on param types and description text. (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 ;-) Ross -- Ross J. Reedstrom, Ph.D., NSBRI Research Scientist/Programmer Computer and Information Technology Institute Rice University, 6100 S. Main St., Houston, TX 77005