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:
Show quoted text
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?