New option ie
will add IF EXISTS
to a bunch of places.
New option ine
will add IF NOT EXISTS
to a bunch of places.
New option drop
will add drop statements in the beginning of the script.
One can pass options as text array to ddlx_create
and ddlx_script
and other functions. Like:
mydb=# select ddlx_create('my_table'::regclass , '{ine}')
Now one can get individual parts of object definition. Try:
mydb=# select * from ddlx_definitions('my_table'::regclass)
Some internal factorization to make this more sensible.