Re: Get the table creation DDL

From: Mladen Gogala <gogala(dot)mladen(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Get the table creation DDL
Date: 2022-07-10 19:26:49
Message-ID: ff439ee6-66f7-9b8d-d552-592e19547552@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Igor Korot 2022-07-10 21:00:59 Re: Get the table creation DDL
Previous Message Igor Korot 2022-07-10 18:59:40 Re: Get the table creation DDL