PostgreSQL - export/import schema only

Export

Use -s to specify schema only

pg_dump <src_database_name> -s > schema.sql

(Optional) Use -t to specify table. For more than 1 table just add more -t.

 pg_dump <src_database_name> -s -t <table1_name> -t <table2_name> > schema.sql

Import

psql <dest_database_name> -f schema.sql

Credit:

• How to Import / Export in Postgres Database ?
• How to import existing *.sql files in Postgresql 8.4?
• pg_dump