Skip to content

CREATE TABLE

Pre-release
Pre-release
Compare
Choose a tag to compare
@lacanoid lacanoid released this 20 Jun 21:51
· 193 commits to master since this release

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.