PostgreSQL support (publications & subscriptions)

[nene]

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