I need to backup and restore a DB. In this particular case the data in the database is not important (strange hum...) but only the schema to put new data...
I m thinking use the pg_dump:
pg_dump -c -C -s schema > file.out
Almost....
-s says "only dump the structure of the database"
If you want to dump a specific named schema inside the database, you'd use: