pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  

help / color / mirror / Atom feed

Source of User Defined functions.
2+ messages / 2 participants
[nested] [flat]

* Source of User Defined functions.
@ 2008-09-09 20:49  Saii <saiisia@gmail.com>
  0 siblings, 1 reply; 2+ messages in thread

From: Saii @ 2008-09-09 20:49 UTC (permalink / raw)
  To: pgsql-admin

Hello,

  I have a questions regarding the location of source code of user defined
functions in Postgres. I used the following query to get all function names
but I
  do not see the source code of the user defined functions. In the 'prosrc'
column, data is available for trigger functions only. Is there any other
table/column where function source code can be found?

SELECT p.proname, p.pronargs, t.typname,p.proowner, p.prosrc
  FROM pg_proc p, pg_language l, pg_type t
  WHERE p.prolang = l.oid
    and p.prorettype = t.oid
    and l.lanname in ('sql', 'plpgsql'  )
    and proowner = 964227
  ORDER BY proname;


  Thanks much
  Saii

^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: Source of User Defined functions.
@ 2008-09-09 22:04  Alvaro Herrera <alvherre@commandprompt.com>
  parent: Saii <saiisia@gmail.com>
  0 siblings, 0 replies; 2+ messages in thread

From: Alvaro Herrera @ 2008-09-09 22:04 UTC (permalink / raw)
  To: Saii <saiisia@gmail.com>; +Cc: pgsql-admin

Saii escribió:
> Hello,
> 
>   I have a questions regarding the location of source code of user defined
> functions in Postgres. I used the following query to get all function names
> but I
>   do not see the source code of the user defined functions. In the 'prosrc'
> column, data is available for trigger functions only. Is there any other
> table/column where function source code can be found?

prosrc is source for all plpgsql functions (and others).  If you have C
functions, you cannot see the code because all we know is a shared
library to load and function name to call.

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.



^ permalink  raw  reply  [nested|flat] 2+ messages in thread

end of thread, other threads:[~2008-09-09 22:04 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2008-09-09 20:49 Source of User Defined functions. Saii <saiisia@gmail.com>
2008-09-09 22:04 ` Alvaro Herrera <alvherre@commandprompt.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox