What you can do is: - list all tables in schema \dt YOUR_SCHEMA.* - and then get the create table for each of them via: \d+ table_name ... View more