From: | Merlin Moncure <mmoncure(at)gmail(dot)com> |
---|---|
To: | Wim Bertels <wim(dot)bertels(at)khleuven(dot)be> |
Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: CRUD plpgsql generator |
Date: | 2011-06-22 14:02:28 |
Message-ID: | BANLkTinStd6Py4S+g2GgFoDQ3Sg+SvFUOA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Wed, Jun 22, 2011 at 5:40 AM, Wim Bertels <wim(dot)bertels(at)khleuven(dot)be> wrote:
> Hallo,
>
> does anyone have know of a free CRUD generator
> for generating plpgsql functions for doing CRUD operations on all the
> tables of a database or schema or just one table or..
>
> cf
> http://postgresql.1045698.n5.nabble.com/CRUD-functions-similar-to-SQL-stored-procedurs-for-postgresql-tables-td3372030.html
> http://myleshenderson.com/index.php/2007/11/16/postgresql-insert-function-generator
It wouldn't be that difficult to make one IMO, but are you sure you
really want to do this? ISTM it's a bit of an anti-pattern. If I had
to do it, I would make a plpgsql function which would generate the
functions by querying information_schema and generating create
function statements via 'execute'.
merlin
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2011-06-22 14:36:15 | Re: Where is pg_create_restore_point funciton in 9.1a2 ? |
Previous Message | Misa Simic | 2011-06-22 13:55:05 | Re: unique across two tables |