Hmmm.. I probably should have mentioned that it's not a "normal" dump, but one including imported shapefiles. So my dump comes from this: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 byusing 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.pg_dump -Fc ...and - sorry, myself not being an expert - it seems to me that this file is not editable anymore.No, but if you run pg_restore -l <my_dump_file> that will output a list of objects that IS editable. Then pg_restore -L ... will only restore the items in that list.
Ah, ok. Right, I can see that. But I don't really get how the final command will look like. pg_restore -L <file_without_FUNCTIONS> -d <my_database>But somewhere I have to indicate the original file, no? I mean, where do 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... Thanks for any advice. Stef
smime.p7s
Description: S/MIME cryptographic signature
