Supported SQL Reference
bit.io's functionality maps onto the PostgreSQL 14 standard, meaning users can employ PostgreSQL syntax to create, delete, and modify their schemas, tables, and views. bit.io supports most but not every PostgreSQL construct, and we've outlined what we do not support below. The limitations on supported SQL statements and PostgreSQL functions mostly involve system administration and security/role management, which are handled by bit.io.
If you're looking for postgres documentation and it's not referenced below, visit the official PostgreSQL 14 documentation.
Partially Supported SQL Statements
Statement | Description | Limitation |
---|---|---|
CREATE PROCEDURE /CREATE FUNCTION | define a new function | only languages of SQL and PL/pgSQL are supported |
COPY | copy data between a file and a table | only STDIN/STDOUT is supported |
Unsupported SQL Statements
We do not yet support the following PostgreSQL commands:
Statement |
---|
ALTER COLLATION |
ALTER DATABASE |
ALTER DEFAULT PRIVILEGES |
ALTER EVENT TRIGGER |
ALTER FOREIGN DATA WRAPPER |
ALTER POLICY |
ALTER ROLE |
ALTER SERVER |
ALTER SYSTEM |
ALTER TABLESPACE |
ALTER USER MAPPING |
CREATE ACCESS METHOD |
CREATE CONVERSION |
CREATE DATABASE |
CREATE EVENT TRIGGER |
CREATE FOREIGN DATA WRAPPER |
CREATE FOREIGN TABLE |
CREATE LANGUAGE |
CREATE POLICY |
CREATE ROLE |
CREATE SERVER |
CREATE TABLESPACE |
CREATE TRANSFORM |
CREATE USER MAPPING |
DROP DATABASE |
DROP OWNED |
DROP ROLE |
DROP TABLESPACE |
DROP USER MAPPING |
GRANT |
IMPORT FOREIGN SCHEMA |
LOAD |
REASSIGN OWNED |
SECURITY LABEL |
Unsupported Postgres SQL Functions
Additionally, the following functions are not allowed:
inet_client_addr |
inet_client_port |
inet_server_addr |
inet_server_port |
pg_reload_conf |
pg_log_backend_memory_contexts |
pg_current_logfile |
pg_rotate_logfile |
pg_cancel_backend |
pg_log_backend_memory_contexts |
pg_reload_conf |
pg_rotate_logfile |
pg_terminate_backend |
pg_create_restore_point |
pg_current_wal_flush_lsn |
pg_current_wal_insert_lsn |
pg_current_wal_lsn |
pg_start_backup |
pg_stop_backup |
pg_stop_backup |
pg_is_in_backup |
pg_backup_start_time |
pg_switch_wal |
pg_walfile_name |
pg_walfile_name_offset |
pg_wal_lsn_diff |
pg_is_in_recovery |
pg_last_wal_receive_lsn |
pg_last_wal_replay_lsn |
pg_last_xact_replay_timestamp |
pg_is_wal_replay_paused |
pg_get_wal_replay_pause_state |
pg_promote |
pg_wal_replay_pause |
pg_wal_replay_resume |
pg_create_physical_replication_slot |
pg_drop_replication_slot |
pg_create_logical_replication_slot |
pg_copy_physical_replication_slot |
pg_copy_logical_replication_slot |
pg_logical_slot_get_changes |
pg_logical_slot_peek_changes |
pg_logical_slot_get_binary_changes |
pg_logical_slot_peek_binary_changes |
pg_replication_slot_advance |
pg_replication_origin_create |
pg_replication_origin_drop |
pg_replication_origin_oid |
pg_replication_origin_session_setup |
pg_replication_origin_session_reset |
pg_replication_origin_session_is_setup |
pg_replication_origin_session_progress |
pg_replication_origin_xact_setup |
pg_replication_origin_xact_reset |
pg_replication_origin_advance |
pg_replication_origin_progress |
pg_logical_emit_message |
pg_ls_dir |
pg_ls_logdir |
pg_ls_waldir |
pg_ls_archive_statusdir |
pg_ls_tmpdir |
pg_read_file |
pg_read_binary_file |
pg_stat_file |
Supported Extensions
Extension name |
---|
tsm_system_time |
quantile |
pgcrypto |
pg_stat_statements |
uuid-ossp |
btree_gist |
btree_gin |
citext |
cube |
dict_int |
earthdistance |
fuzzystrmatch |
hstore |
intarray |
isn |
lo |
ltree |
pg_trgm |
plpgsql |
seg |
tablefunc |
tcn |
tsm_system_rows |
tsm_system_time |
unaccent |
postgis |
postgis_raster |
postgis_tiger_geocoder |
postgis_topology |
timescaledb |
vector (pgvector) |
Contact [email protected] if you'd like additional extensions added
Disallowed table access
Schema Name | Table Name |
---|---|
pg_catalog | pg_db_role_setting |
pg_catalog | pg_authid |
Updated 2 months ago