sql-parser-cst icon indicating copy to clipboard operation
sql-parser-cst copied to clipboard

Postgres support (schemas)

Open nene opened this issue 1 year ago • 0 comments

  • [x] CREATE SCHEMA
    • [x] IF NOT EXISTS
    • [x] optional schema_name
    • [x] AUTHORIZATION role_specification:
      • [x] user_name
      • [x] CURRENT_ROLE | CURRENT_USER | SESSION_USER
    • [x] schema elements:
      • [x] CREATE TABLE
      • [x] CREATE VIEW
      • [x] CREATE INDEX
      • [x] CREATE SEQUENCE
      • [x] CREATE TRIGGER
      • [x] GRANT
  • [x] DROP SCHEMA
    • [x] IF EXISTS
    • [x] multiple names
    • [x] CASCADE | RESTRICT
  • [x] ALTER SCHEMA
    • [x] RENAME TO new_name
    • [x] OWNER TO { new_owner | CURRENT_ROLE | CURRENT_USER | SESSION_USER }
  • [ ] IMPORT FOREIGN SCHEMA
    • [ ] remote_schema
    • [ ] { LIMIT TO | EXCEPT } ( table_name [, ...] )
    • [ ] FROM SERVER server_name
    • [ ] INTO local_schema
    • [ ] OPTIONS ( option 'value' [, ... ] )

nene avatar Jan 29 '24 12:01 nene