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.
Hmmm.. I probably should have mentioned that it's not a "normal" dump, but one including imported shapefiles. So my dump comes from this:
pg_dump -Fc ...and - sorry, myself not being an expert - it seems to me that this file is not editable anymore.
When I try to dump the file in text form, it gets rather big, and when trying to import it, I get this:
server closed the connection unexpectedly This probably means the server terminated abnormally before or while processing the request. connection to server was lost Stef
<<attachment: smime.p7s>>
