PostgreSQL support (publications & subscriptions)

[nene]

• CREATE PUBLICATION
  • name
  • FOR ALL TABLES
  • FOR ALL SEQUENCES (in latest dev version)
  • FOR publication_object [, ... ] where publication_object is one of:
    • TABLE [ ONLY ] table_name [ * ] [ ( column_name [, ... ] ) ] [ WHERE ( expression ) ] [, ... ]
    • multiple (table-column-where) defs
    • TABLES IN SCHEMA { schema_name | CURRENT_SCHEMA } [, ... ]
    • multiple schemas
  • WITH ( publication_parameter [= value] [, ... ] )
• ALTER PUBLICATION
  • name
  • ADD publication_object [, ...]
  • SET publication_object [, ...]
  • DROP publication_object [, ...] with publication_object being one of:
    • TABLE [ ONLY ] table_name [ * ] [ ( column_name [, ... ] ) ] [ WHERE ( expression ) ] [, ... ]
    • TABLES IN SCHEMA { schema_name | CURRENT_SCHEMA } [, ... ]
  • SET ( publication_parameter [= value] [, ... ] )
  • OWNER TO { new_owner | CURRENT_ROLE | CURRENT_USER | SESSION_USER }
  • RENAME TO new_name
• DROP PUBLICATION
  • IF EXISTS
  • name, ...
  • CASCADE | RESTRICT
• CREATE SUBSCRIPTION
  • subscription_name CONNECTION 'conninfo' PUBLICATION publication_name [, ...]
  • WITH ( subscription_parameter [= value] [, ... ] )
• ALTER SUBSCRIPTION
  • CONNECTION 'conninfo'
  • SET PUBLICATION publication_name [, ...] [ WITH ( publication_option [= value] [, ... ] ) ]
  • ADD PUBLICATION publication_name [, ...] [ WITH ( publication_option [= value] [, ... ] ) ]
  • DROP PUBLICATION publication_name [, ...] [ WITH ( publication_option [= value] [, ... ] ) ]
  • REFRESH PUBLICATION [ WITH ( refresh_option [= value] [, ... ] ) ]
  • ENABLE
  • DISABLE
  • SET ( subscription_parameter [= value] [, ... ] )
  • SKIP ( skip_option = value )
  • OWNER TO { new_owner | CURRENT_ROLE | CURRENT_USER | SESSION_USER }
  • RENAME TO new_name
• DROP SUBSCRIPTION
  • IF EXISTS
  • name
  • CASCADE | RESTRICT