Postgres support (views)

[nene]

• CREATE VIEW
  • OR REPLACE
  • TEMP | TEMPORARY
  • RECURSIVE
  • ( column_name [, ...] ) ]
  • WITH ( view_option_name [= view_option_value] [, ... ] )
  • AS query
  • WITH [ CASCADED | LOCAL ] CHECK OPTION
• CREATE MATERIALIZED VIEW
  • IF NOT EXISTS
  • USING method
  • WITH ( storage_parameter [= value] [, ... ] )
  • TABLESPACE tablespace_name
  • WITH [ NO ] DATA
• ALTER VIEW
  • IF EXISTS
  • ALTER [ COLUMN ] column_name SET DEFAULT expression
  • ALTER [ COLUMN ] column_name DROP DEFAULT
  • OWNER TO { new_owner | CURRENT_ROLE | CURRENT_USER | SESSION_USER }
  • RENAME [ COLUMN ] column_name TO new_column_name
  • RENAME TO new_name
  • SET SCHEMA new_schema
  • SET ( view_option_name [= view_option_value] [, ... ] )
  • RESET ( view_option_name [, ... ] )
• ALTER MATERIALIZED VIEW
  • [ NO ] DEPENDS ON EXTENSION extension_name
  • SET TABLESPACE new_tablespace [ NOWAIT ]
  • multiple actions:
    • ALTER [ COLUMN ] column_name ...:
      • SET STATISTICS integer
      • SET ( attribute_option = value [, ... ] )
      • RESET ( attribute_option [, ... ] )
      • SET STORAGE { PLAIN | EXTERNAL | EXTENDED | MAIN | DEFAULT }
      • SET COMPRESSION compression_method
    • CLUSTER ON index_name
    • SET WITHOUT CLUSTER
    • SET ACCESS METHOD new_access_method
    • SET TABLESPACE new_tablespace
    • SET ( storage_parameter [= value] [, ... ] )
    • RESET ( storage_parameter [, ... ] )
    • OWNER TO { new_owner | CURRENT_ROLE | CURRENT_USER | SESSION_USER }
• DROP VIEW
  • IF EXISTS
  • multiple views
  • CASCADE | RESTRICT
• DROP MATERIALIZED VIEW
• REFRESH MATERIALIZED VIEW
  • CONCURRENTLY
  • name
  • WITH [ NO ] DATA