Re: Get the table creation DDL

Поиск
Список
Период
Сортировка
От Igor Korot
Тема Re: Get the table creation DDL
Дата
Msg-id CA+FnnTzT2-0OXL0abku5iRMz8nOPNWTb-WFnsMFBoJTDudHm_Q@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Get the table creation DDL  (Igor Korot <ikorot01@gmail.com>)
Ответы Re: Get the table creation DDL  (Michael Nolan <htfoot@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Igor Korot
Дата:
Сообщение: Re: Get the table creation DDL
Следующее
От: Ray O'Donnell
Дата:
Сообщение: Re: Get the table creation DDL