I have database on production server that backups every day. Database is not
big ~ 10mb.
But I added several tables that takes big capacity and I don't want to backup
data from them.
So, I backup my database in two files: schema and data:
pg_dump -s -E utf-8 -f ${filename.schema} -F custom -n pu
In the end, decided to make easier: make a complete dump except tables that I
don't want to backup, then just dump schema of these tables. So I have 2 files:
schema+data for all except table1 and table2, schema only for table1 and table2.
It's a strangely that pg_restore is still no option to che