News for hackers. Stuff that matters.
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.
Re:Features I'd Like in PostgreSQL by drodgers on Saturday January 28, 2023 @08:20PM (#34563902)
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.