From: bandeng <postgredb@gmail.com>
To: pgsql-sql@postgresql.org
Subject: Re: view function on pg_toast
Date: Thu, 24 Mar 2005 04:53:33 +0800
Message-ID: <3817e22905032312536dabf150@mail.gmail.com> (raw)
In-Reply-To: <14443615312.20050323100919@mail.ru>
References: <3817e229050322193958e2837a@mail.gmail.com>
<6843119421.20050323100103@mail.ru>
<14443615312.20050323100919@mail.ru>
to Michael,
We use pg manager from EMS and misstype. it should be created on
public but on pg_toast
On Wed, 23 Mar 2005 10:09:19 +0500, Mihail Nasedkin
<m.nasedkin.perm@mail.ru> wrote:
> 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
>
>
--
Gutten Aben Sugeng Sonten, Jangane Kurang Santen
bandeng....................
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: postgredb@gmail.com
Subject: Re: view function on pg_toast
In-Reply-To: <3817e22905032312536dabf150@mail.gmail.com>
* 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