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 |
---|---|---|
| define a new function | only language of |
| copy data between a file and a table | only |
Unsupported SQL Statements
We do not yet support the following PostgreSQL commands:
Statement |
---|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
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 |
---|
|
|
Contact [email protected] if you'd like additional extensions added
Updated about 1 month ago