Re: [GENERAL] Dump schema without the functions

[Stefan Schwarzer]

But I don't really get how the final command will look like.

pg_restore -L <file_without_FUNCTIONS> -d <my_database>


all my data now come from? The original dump contains all data; the
newly created via

        pg_restore -l geodataportal.public  | grep -v FUNCTION >
pgdump.geodataportal.public.no-func

has only the TOC. But no data...

But somewhere I have to indicate the original file, no? I mean, where do

Then you feed that file to pg_restore -L, along the original dump file.

pg_restore      -L pgdump.geodataportal.public.no-func
                        -v pgdump.geodataportal.public
                        -U xxx
                        -d geodataportal

Thanks for your help!!

Stef

I mean, that was exactly my question, how this would look like... Ok, figured it out meanwhile:

smime.p7s
Description: S/MIME cryptographic signature