sql-parser-cst
sql-parser-cst copied to clipboard
Postgres support (schemas)
- [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]
- [x] schema elements:
- [x]
CREATE TABLE - [x]
CREATE VIEW - [x]
CREATE INDEX - [x]
CREATE SEQUENCE - [x]
CREATE TRIGGER - [x]
GRANT
- [x]
- [x]
- [x] DROP SCHEMA
- [x]
IF EXISTS - [x] multiple names
- [x]
CASCADE | RESTRICT
- [x]
- [x] ALTER SCHEMA
- [x]
RENAME TO new_name - [x]
OWNER TO { new_owner | CURRENT_ROLE | CURRENT_USER | SESSION_USER }
- [x]
- [ ] IMPORT FOREIGN SCHEMA
- [ ]
remote_schema - [ ]
{ LIMIT TO | EXCEPT } ( table_name [, ...] ) - [ ]
FROM SERVER server_name - [ ]
INTO local_schema - [ ]
OPTIONS ( option 'value' [, ... ] )
- [ ]