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

From Igor Korot
Subject Re: Get the table creation DDL
Date
Msg-id CA+FnnTzT2-0OXL0abku5iRMz8nOPNWTb-WFnsMFBoJTDudHm_Q@mail.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  (Michael Nolan <htfoot@gmail.com>)
List pgsql-general
Hi,

On Sun, Jul 10, 2022 at 11:47 AM Igor Korot <ikorot01@gmail.com> wrote:
>
> Hi, Michael,
>
> On Sun, Jul 10, 2022 at 11:13 AM Michael Nolan <htfoot@gmail.com> wrote:
> >
> >
> >
> > On Sun, Jul 10, 2022 at 10:28 AM Igor Korot <ikorot01@gmail.com> wrote:
> >>
> >> Hi,
> >> Is there a query I can execute that will give me CREATE TABLE() command
> >> used to create a table?
>
> So there is no "query" per se?
> Also how do I pass the table name?
>
> Thank you.
>
> >>
> >> Thank you.
> >
> >
> > Use pg_dump --schema-only

In addition:

Can I send it to execute with PQexec() or SQLExecDirect()?

It is not a query, but an external command, so I'm wondering...

Thank you.

> > --
> > Mike Nolan



pgsql-general by date:

Previous
From: Igor Korot
Date:
Subject: Re: Get the table creation DDL
Next
From: Ray O'Donnell
Date:
Subject: Re: Get the table creation DDL