Re: deparsing utility commands

Поиск
Список
Период
Сортировка
Искать
От
Ryan Pedela
Тема
Re: deparsing utility commands
Дата
Msg-id
CACu89FTn23NKLcFbgo57u7BAy8fXFE2vwucEHJD2F7n92VLerw@mail.gmail.com
Ответ на
Список
Дерево обсуждения
deparsing utility commands Alvaro Herrera <alvherre@2ndquadrant.com>
Re: deparsing utility commands Andres Freund <andres@2ndquadrant.com>
Re: deparsing utility commands Alvaro Herrera <alvherre@2ndquadrant.com>
Re: deparsing utility commands Stephen Frost <sfrost@snowman.net>
Re: deparsing utility commands Alvaro Herrera <alvherre@2ndquadrant.com>
Re: deparsing utility commands Stephen Frost <sfrost@snowman.net>
Re: deparsing utility commands Alvaro Herrera <alvherre@2ndquadrant.com>
Re: deparsing utility commands Stephen Frost <sfrost@snowman.net>
Re: deparsing utility commands Alvaro Herrera <alvherre@2ndquadrant.com>
Re: deparsing utility commands Andres Freund <andres@2ndquadrant.com>
Re: deparsing utility commands Alvaro Herrera <alvherre@2ndquadrant.com>
Re: deparsing utility commands Andres Freund <andres@2ndquadrant.com>
Re: deparsing utility commands Alvaro Herrera <alvherre@2ndquadrant.com>
Re: deparsing utility commands Stephen Frost <sfrost@snowman.net>
Re: deparsing utility commands Alvaro Herrera <alvherre@2ndquadrant.com>
Re: deparsing utility commands Stephen Frost <sfrost@snowman.net>
Re: deparsing utility commands Stephen Frost <sfrost@snowman.net>
Re: deparsing utility commands Alvaro Herrera <alvherre@2ndquadrant.com>
Re: deparsing utility commands Stephen Frost <sfrost@snowman.net>
Re: deparsing utility commands Andres Freund <andres@2ndquadrant.com>
Re: deparsing utility commands Andres Freund <andres@2ndquadrant.com>
Re: deparsing utility commands Alvaro Herrera <alvherre@2ndquadrant.com>
Re: deparsing utility commands Stephen Frost <sfrost@snowman.net>
Re: deparsing utility commands Andres Freund <andres@2ndquadrant.com>
Re: deparsing utility commands Stephen Frost <sfrost@snowman.net>
Re: deparsing utility commands Andres Freund <andres@2ndquadrant.com>
Re: deparsing utility commands Stephen Frost <sfrost@snowman.net>
Re: deparsing utility commands Alvaro Herrera <alvherre@2ndquadrant.com>
Re: deparsing utility commands Andres Freund <andres@2ndquadrant.com>
Re: deparsing utility commands Stephen Frost <sfrost@snowman.net>
Re: deparsing utility commands Ryan Pedela <rpedela@datalanche.com>
Re: deparsing utility commands Andres Freund <andres@2ndquadrant.com>
Re: deparsing utility commands Alvaro Herrera <alvherre@2ndquadrant.com>
Re: deparsing utility commands Stephen Frost <sfrost@snowman.net>
Re: deparsing utility commands Alvaro Herrera <alvherre@2ndquadrant.com>
Re: deparsing utility commands Alvaro Herrera <alvherre@2ndquadrant.com>
Re: deparsing utility commands Ryan Pedela <rpedela@datalanche.com>
Re: deparsing utility commands Robert Haas <robertmhaas@gmail.com>
Re: deparsing utility commands Andres Freund <andres@anarazel.de>
Re: deparsing utility commands Alvaro Herrera <alvherre@2ndquadrant.com>
Re: deparsing utility commands Alvaro Herrera <alvherre@2ndquadrant.com>
Re: deparsing utility commands Alvaro Herrera <alvherre@2ndquadrant.com>
Re: deparsing utility commands David Steele <david@pgmasters.net>
Re: deparsing utility commands Amit Kapila <amit.kapila16@gmail.com>
Re: deparsing utility commands Alvaro Herrera <alvherre@2ndquadrant.com>
Re: deparsing utility commands Alvaro Herrera <alvherre@2ndquadrant.com>
Re: deparsing utility commands Alvaro Herrera <alvherre@2ndquadrant.com>
Re: deparsing utility commands David Steele <david@pgmasters.net>
Re: deparsing utility commands Alvaro Herrera <alvherre@2ndquadrant.com>
Re: deparsing utility commands "Shulgin, Oleksandr" <oleksandr.shulgin@zalando.de>
Re: deparsing utility commands "Shulgin, Oleksandr" <oleksandr.shulgin@zalando.de>
Re: deparsing utility commands Jim Nasby <Jim.Nasby@BlueTreble.com>
Re: deparsing utility commands Alvaro Herrera <alvherre@2ndquadrant.com>
Re: deparsing utility commands Jim Nasby <Jim.Nasby@BlueTreble.com>
Re: deparsing utility commands Alvaro Herrera <alvherre@2ndquadrant.com>
Re: deparsing utility commands "Shulgin, Oleksandr" <oleksandr.shulgin@zalando.de>
Re: deparsing utility commands Alvaro Herrera <alvherre@2ndquadrant.com>
Re: deparsing utility commands "Shulgin, Oleksandr" <oleksandr.shulgin@zalando.de>
Re: deparsing utility commands Ajin Cherian <itsajin@gmail.com>
Re: deparsing utility commands Ajin Cherian <itsajin@gmail.com>
Re: deparsing utility commands Peter Eisentraut <peter.eisentraut@enterprisedb.com>
Re: deparsing utility commands Ajin Cherian <itsajin@gmail.com>
Re: deparsing utility commands Ajin Cherian <itsajin@gmail.com>
Re: deparsing utility commands "Shulgin, Oleksandr" <oleksandr.shulgin@zalando.de>
Re: deparsing utility commands Alvaro Herrera <alvherre@2ndquadrant.com>
Re: deparsing utility commands Fabrízio de Royes Mello <fabriziomello@gmail.com>
Re: deparsing utility commands Dimitri Fontaine <dimitri@2ndQuadrant.fr>
Re: deparsing utility commands David Steele <david@pgmasters.net>
On Tue, Feb 24, 2015 at 6:48 AM, Alvaro Herrera <alvherre@2ndquadrant.com> wrote:
Stephen Frost wrote:

I'm thinking something like
 SELECT * FROM pg_creation_commands({'pg_class'::regclass, 'sometable'::pg_class});
would return a set of commands in the JSON-blob format that creates the
table.  The input argument is an array of object addresses, so that you
can request creation commands for multiple objects.  (It's not my
intention to provide this functionality right away, but if somebody else
wants to work on top of the current deparse patch, by my guest; if it
proves simple enough we can still get it into 9.5 as part of this
patch.)

 +1

Another possible function could be to diff two relations to produce a set of DDL commands that could be used for schema migrations.

Also thank you very much! CREATE/ALTER support in event triggers is the upcoming feature I am most excited about, and I am happy to see progress.

Thanks,
Ryan Pedela 
В списке pgsql-hackers по дате отправления
От: Alvaro Herrera
Дата:
От: Corey Huinker
Дата:
FAQ