copy tables/fields of postgreSQL database

Question

I'd like to create a new database with the same tables/fields as an existing database. I don't need any of the rows, I just need the schema. Is there a way to do this?

Answer 1

You can copy just the schema using pg_dump, then restore it in your new database.

pg_dump --schema-only