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

DO

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

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


Did this page help you?