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`