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
smime.p7s
Description: S/MIME cryptographic signature
