Postgres Pro
Downloads
Home   >   mailing lists

Re: Get the table creation DDL - Mailing list pgsql-general

From Mladen Gogala
Subject Re: Get the table creation DDL
Date
Msg-id ff439ee6-66f7-9b8d-d552-592e19547552@gmail.com
Whole thread Raw
In response to Re: Get the table creation DDL  (Igor Korot <ikorot01@gmail.com>)
Responses Re: Get the table creation DDL  (Igor Korot <ikorot01@gmail.com>)
List pgsql-general
Tree view
On 7/10/22 12:47, Igor Korot wrote:
So there is no "query" per se?
Also how do I pass the table name?

Thank you.

You can create one from the catalog tables. Personally, I would use INFORMATION_SCHEMA to avoid pg_class and pg_attribute. However, there is an extension which does that for you. Somebody else has already done the hard work.

-- 
Mladen Gogala
Database Consultant
Tel: (347) 321-1217
https://dbwhisperer.wordpress.com

pgsql-general by date:

Previous
From: Igor Korot
Date:
Subject: Re: Get the table creation DDL
Next
From: Igor Korot
Date:
Subject: Re: Get the table creation DDL