How to dump the DDLs of all table in the same DB?

How to dump the DDLs of all table in the same DB?
It can not work with the following script:
pg_dump -h host -p port -U username -s -t t1, t2 dbname > struct.sql

Hi! Have your read through the docs here, which explains how to import a db using pgdump? Migrate from Postgres | CockroachDB Docs

thx!
I will try and feedback

You can also use SHOW CREATE ALL TABLES

1 Like