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

StatementDescriptionLimitation
CREATE PROCEDURE/CREATE FUNCTIONdefine a new functiononly languages of SQL and PL/pgSQL are supported
COPYcopy data between a file and a tableonly 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
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

Contact [email protected] if you'd like additional extensions added

Disallowed table access

Schema NameTable Name
pg_catalogpg_db_role_setting
pg_catalogpg_authid