| From: | Igor Korot <ikorot01(at)gmail(dot)com> |
|---|---|
| To: | Michael Nolan <htfoot(at)gmail(dot)com> |
| Cc: | "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>, pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Get the table creation DDL |
| Date: | 2022-07-10 17:18:33 |
| Message-ID: | CA+FnnTzT2-0OXL0abku5iRMz8nOPNWTb-WFnsMFBoJTDudHm_Q@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hi,
On Sun, Jul 10, 2022 at 11:47 AM Igor Korot <ikorot01(at)gmail(dot)com> wrote:
>
> Hi, Michael,
>
> On Sun, Jul 10, 2022 at 11:13 AM Michael Nolan <htfoot(at)gmail(dot)com> wrote:
> >
> >
> >
> > On Sun, Jul 10, 2022 at 10:28 AM Igor Korot <ikorot01(at)gmail(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ray O'Donnell | 2022-07-10 17:47:18 | Re: Get the table creation DDL |
| Previous Message | Igor Korot | 2022-07-10 16:47:48 | Re: Get the table creation DDL |