Re: Dump table from schema and function from another one

From: Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com>
To: Luke Luke <Jen(dot)Luke(at)seznam(dot)cz>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Dump table from schema and function from another one
Date: 2013-03-19 20:18:04
Message-ID: 5148C7FC.70204@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 03/19/2013 01:02 PM, Luke Luke wrote:
> Hi guys,
> Is it possible to do a postgre dump where I will dump from database
> complete schema[A] (table+data,procedures) and from another schema[B]
> only stored procedures by one dump commnad?

AFAIK there is no way to dump just stored procedures(functions) in any
manner, so the above plan will fail on that point. The ways that have
been suggested in the past is to filter a dump through an external
program to pull the functions out.

>
> Thanks

--
Adrian Klaver
adrian(dot)klaver(at)gmail(dot)com

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jason Dusek 2013-03-19 22:12:04 Re: Analyzing the types of prepared statements
Previous Message Luke Luke 2013-03-19 20:02:16 Dump table from schema and function from another one