Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 03BAF64FEDF for ; Tue, 9 Sep 2008 17:49:52 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 86814-04 for ; Tue, 9 Sep 2008 17:49:44 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from yx-out-2324.google.com (yx-out-2324.google.com [74.125.44.30]) by postgresql.org (Postfix) with ESMTP id 5C51964FD27 for ; Tue, 9 Sep 2008 17:49:43 -0300 (ADT) Received: by yx-out-2324.google.com with SMTP id 8so1259876yxb.73 for ; Tue, 09 Sep 2008 13:49:42 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to :subject:mime-version:content-type; bh=UVPEnZc4je6Fq/4a1bJothvnqF/I5az6nrhddkSaHMI=; b=qbMDnnff3SE5eDV+6AxCHOgzS7faitHpSYcyh3c7z8EhPFi9YQUDI29PU3YYkH0uQM m4YdFwY5CKdtd4qFGLlonP6MJMoVEnGXjS2Db81a/haMunTXpOx54QAH5hPghwi9mLzi bNDWcK4uRnu3DDJX3qFC2jBtGAcdTYcK7CuZk= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:mime-version:content-type; b=X/Oi/4vz6hWHp7EQx5ID/KZNvSOdKKbinhYorwiH+dx1YqbDeotor9AKrCGW7qatFD GuAp+TxYDLjnOlYhrq8IDtcXZseRv/BNl6OR0gcoAXutK+mpwuk9dLpzPjHO6I1zesfg VEDrf4jnlAv27o42k0e8le31SS05r+3v8xClY= Received: by 10.103.250.11 with SMTP id c11mr178315mus.23.1220993381017; Tue, 09 Sep 2008 13:49:41 -0700 (PDT) Received: by 10.103.240.14 with HTTP; Tue, 9 Sep 2008 13:49:40 -0700 (PDT) Message-ID: Date: Tue, 9 Sep 2008 16:49:40 -0400 From: Saii To: pgsql-admin@postgresql.org Subject: Source of User Defined functions. MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_34292_20417436.1220993381019" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 200809/72 X-Sequence-Number: 30165 ------=_Part_34292_20417436.1220993381019 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline 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 ------=_Part_34292_20417436.1220993381019 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline
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

------=_Part_34292_20417436.1220993381019--