Re: view function on pg_toast

From: Mihail Nasedkin <m(dot)nasedkin(dot)perm(at)mail(dot)ru>
To: bandeng <postgredb(at)gmail(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: view function on pg_toast
Date: 2005-03-23 05:09:19
Message-ID: 14443615312.20050323100919@mail.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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(dot)nasedkin(dot)perm(at)mail(dot)ru

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Tambet Matiisen 2005-03-23 08:13:14 Re: "Flattening" query result into columns
Previous Message Mihail Nasedkin 2005-03-23 05:01:03 Re: view function on pg_toast