Postgres Pro
Downloads
Home   >   mailing lists

Re: Dump schema without the functions - Mailing list pgsql-general

From Tom Lane
Subject Re: Dump schema without the functions
Date
Msg-id 19318.1201849813@sss.pgh.pa.us
Whole thread Raw
In response to Dump schema without the functions  (Stefan Schwarzer <stefan.schwarzer@grid.unep.ch>)
Responses Re: Dump schema without the functions
List pgsql-general
Tree view 
Stefan Schwarzer <stefan.schwarzer@grid.unep.ch> writes:
> how can I dump a schema with all tables, but without the functions?

There's no built-in single command for that.  You can accomplish it by
using pg_restore -l to make a list of objects, then edit the list,
then pg_restore -L to restore only the objects in the edited list.

            regards, tom lane

pgsql-general by date:

Previous
From: "Adam Rich"
Date:
Subject: Re: Dump schema without the functions
Next
From: Stefan Schwarzer
Date:
Subject: Re: Dump schema without the functions