Thread: How to view the functions that exists
Hi ! I have a consulta about how Imcan view what are defined on my database, and their deinitions? Thank you Ernesto --------------------------------------------- Este mensaje fue enviado a trav�s de Qnet http://www.qnet.com.pe
On Fri, Nov 09, 2001 at 04:21:57PM +0000, qradius@qnet.com.pe wrote: > Hi ! > > I have a consulta about how Imcan view what are defined on my > database, and their deinitions? When using the command line interface, psql, you can issue: \df <function> where it will give you a list of all functions that begin with the supplied argument. As an example, here, all developers name their functions with a prefix of sp_ (this must be from using MS SQL..) so: \df sp_ will give you a list of all functions. If you want to see the source of the function, you can use \df+ sp_function_name and you get to see the source of all functions that begin with that pattern (again). > Thank you > > Ernesto Hope that helps Antoine
I am using 7.1.2 \d pg_proc and submit some query: select * from pg_proc where ... Antoine Reid wrote: > On Fri, Nov 09, 2001 at 04:21:57PM +0000, qradius@qnet.com.pe wrote: > >>Hi ! >> >>I have a consulta about how Imcan view what are defined on my >>database, and their deinitions? >> > > When using the command line interface, psql, you can issue: > > \df <function> > where it will give you a list of all functions that begin with the supplied > argument. As an example, here, all developers name their functions with a > prefix of sp_ (this must be from using MS SQL..) > > so: \df sp_ will give you a list of all functions. > > If you want to see the source of the function, you can use > > \df+ sp_function_name > > and you get to see the source of all functions that begin with that pattern > (again). > > >>Thank you >> >>Ernesto >> > > Hope that helps > Antoine > > ---------------------------(end of broadcast)--------------------------- > TIP 6: Have you searched our list archives? > > http://archives.postgresql.org > >