Create a new table - postgres docs
Arguments:
tablename
[string] - name for the new tablecolumns
[object] - column names / options -- see column definitions sectionoptions
[object] - table options (optional)temporary
[bool] - default falseifNotExists
[bool] - default falseinherits
[string] - table(s) to inherit fromconstraints
[object] - table constraints see add constraintlike
[string] - table(s) to inherit fromcomment
[string] - adds comment on table
Reverse Operation: dropTable
Drop existing table - postgres docs
Arguments:
tablename
[string] - name of the table to dropoptions
[object] - options:ifExists
[boolean] - drops table only if it existscascade
[boolean] - drops also dependent objects
Rename a table - postgres docs
Arguments:
tablename
[string] - name of the table to renamenew_table
[object] - new name of the table
Reverse Operation: same operation in opposite direction
Alter existing table - postgres docs
Arguments:
tablename
[string] - name of the table to alteroptions
[object] - options:levelSecurity
[string] -DISABLE
,ENABLE
,FORCE
, orNO FORCE