View Operations

Operation: createView

pgm.createView( viewName, options, definition )

IMPORTANT

Create a new view - postgres docs

Arguments

Name	Type	Description
viewName	string	name of the new view
options	object	Check below for available options
definition	string	SQL of SELECT statement

Options

Option	Type	Description
temporary	boolean	adds TEMPORARY clause
replace	boolean	adds OR REPLACE clause
recursive	boolean	adds RECURSIVE clause
columns	string or array	use if you want to name columns differently then inferred from definition
options	object	key value pairs of View Options
checkOption	string	CASCADED or LOCAL

Reverse Operation: dropView

pgm.dropView( viewName, options )

IMPORTANT

Drop a view - postgres docs

Arguments

Name	Type	Description
viewName	string	name of the view to delete
options	object	Check below for available options

Options

Option	Type	Description
ifExists	boolean	drops view only if it exists
cascade	boolean	drops also dependent objects

Operation: alterView

pgm.alterView( viewName, options )

IMPORTANT

Alter a view - postgres docs

Arguments

Name	Type	Description
viewName	string	name of the view to alter
options	object	Check below for available options

Options

Option	Type	Description
checkOption	string	CASCADED, LOCAL or null to reset
options	object	key value (null to reset) pairs of View Options

Operation: alterViewColumn

pgm.alterViewColumn( viewName, columnName, options )

IMPORTANT

Alter a view column - postgres docs

Arguments

Name	Type	Description
viewName	string	name of the view to alter
columnName	string	name of the column to alter
options	object	Check below for available options

Options

Option	Type	Description
default	string	default value of column

Operation: renameView

pgm.renameView( viewName, newViewName )

IMPORTANT

Rename a view - postgres docs

Arguments

Name	Type	Description
viewName	string	old name of the view
newViewName	string	new name of the view