pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Mihail Nasedkin <m.nasedkin.perm@mail.ru>
To: bandeng <postgredb@gmail.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: view function on pg_toast
Date: Wed, 23 Mar 2005 10:09:19 +0500
Message-ID: <14443615312.20050323100919@mail.ru> (raw)
In-Reply-To: <6843119421.20050323100103@mail.ru>
References: <3817e229050322193958e2837a@mail.gmail.com>
	<6843119421.20050323100103@mail.ru>

MN> March, 23 2005, 8:39:31:

b>> hello guys,

b>> I need help.  I have functions but it is saved to pg_toast, when I
b>> dump the database, the function from pg_toast is not copied. so is
b>> there any sql or syntax to view function data ?


MN> xxx:=\d pg-catalog.pg_proc
xxx:=\d pg_catalog.pg_proc

MN> xxx:=select procsrc from pg-catalog.pg_proc where proname=... and
MN> pronamespace=...;
xxx:=select procsrc from pg_catalog.pg_proc where proname=... and
pronamespace=...;





-- 
Regards,
 Mihail Nasedkin                         mailto:m.nasedkin.perm@mail.ru




view thread (5+ messages)  latest in thread

Message-ID: <14443615312.20050323100919@mail.ru>
Permalink:  ../14443615312.20050323100919@mail.ru/
Also on:    postgresql.org/message-id/14443615312.20050323100919@mail.ru

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: m.nasedkin.perm@mail.ru, postgredb@gmail.com
  Subject: Re: view function on pg_toast
  In-Reply-To: <14443615312.20050323100919@mail.ru>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

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