Re:Features I'd Like in PostgreSQL
by sroussey on Saturday January 28, 2023 @06:23PM
(#34563062)
Also, MySQL's `show create table ...` would be great.
[ Parent
| on HN ]
I've never looked into this for Postgres itself, but AWS Redshift (a postgres derivative) has enough info in the system tables to reconstruct a create table statement using a view (see: https://raw.githubusercontent.com/awslabs/amazon-redshift-ut...) and I'd guess that you can do the same for Postgres.