bit.io's functionality maps onto the PostgreSQL 12 standard, meaning users can employ PostgreSQL syntax to create, delete, and modify their repositories, tables, and views. However, bit.io does not support every PostgreSQL construct, so we've outlined our current support below.

📘
Repositories in bit.io map onto schemas in PostgreSQL, so we will refer to schemas as repositories throughout the documentation.

SQL Statements

We support the following PostgreSQL commands:

Statement	Description	Documentation
`ALTER TABLE`	change a table's definition	`ALTER TABLE` Documentation
`ALTER VIEW`	change a view's definition	`ALTER VIEW` Documentation
`BEGIN`	start a new transaction	`BEGIN` Documentation
`COMMIT`	close the current transaction and commit any changes	`COMMIT` Documentation
`COPY`	copy data rows to/from a table or view	`COPY` Documentation
`CREATE TABLE`	define a new table	`CREATE TABLE` Documentation
`CREATE VIEW`	define a new view	`CREATE VIEW` Documentation
`DELETE`	delete rows from a table or view	`DELETE` Documentation
`DROP TABLE`	delete a table instance	`DROP TABLE` Documentation
`DROP VIEW`	delete a view instance	`DROP VIEW` Documentation
`EXECUTE`	execute a prepared statement	`EXECUTE` Documentation
`INSERT`	insert data rows into a table or view	`INSERT` Documentation
`PREPARE`	create a prepared statement	`PREPARE` Documentation
`RELEASE SAVEPOINT`	delete a savepoint	`RELEASE SAVEPOINT` Documentation
`ROLLBACK`	cancel transaction and rollback any changes made	`ROLLBACK` Documentation
`ROLLBACK TO SAVEPOINT`	discard any changes made after the creation of a savepoint in a transaction	`ROLLBACK TO SAVEPOINT` Documentation
`SAVEPOINT`	create a new savepoint	`SAVEPOINT` Documentation
`SELECT`	retrieve data rows from a set of tables or views	`SELECT` Documentation
`START TRANSACTION`	start a new transaction block	`START TRANSACTION` Documentation
`TRUNCATE`	delete all rows from a table or view	`TRUNCATE` Documentation
`UPDATE`	change the contents of a table or view's data rows	`UPDATE` Documentation
`VALUES`	compute a set of data rows	`VALUES` Documentation

SQL Types

Supported SQL data types include:

Type	Examples	Documentation
Integer & Float	`INTEGER`, `REAL`	Integer & Float Types Documentation
Character	`TEXT`, `VARCHAR`	Character Types Documentation
Binary Data	`bytea`	Binary Data Types Documentation
Date/Time	`DATE`, `TIMESTAMP`	Date/Time Types Documentation
Boolean	`BOOLEAN`	Boolean Types Documentation
Bit String	`BIT(n)`, `VARBIT(n)`	Bit String Types Documentation
JSON	`JSON`, `JSONB`	JSON Types Documentation

Schema Definitions

Type	Supported	Documentation
Define a new repository	only in web app	`CREATE SCHEMA` is currently unsupported
Define a new table	✓	`CREATE TABLE` Documentation
Define a new view	✓	`CREATE VIEW` Documentation
Modify a repository	only in web app	`ALTER SCHEMA` is currently unsupported
Rename a table	✓	`ALTER TABLE` Documentation
Modify a view's definition	𐄂	`ALTER VIEW` Documentation
Add columns to a table	✓	`ALTER TABLE` Documentation
Rename a table's columns	✓	`ALTER TABLE` Documentation
Modify a column's data type	✓	`ALTER TABLE` Documentation
Modify a column's default value	✓	`ALTER TABLE` Documentation
Modify a column's null status	✓	`ALTER TABLE` Documentation
Delete columns from a table	✓	`ALTER TABLE` Documentation
Delete a repository	only in web app	`DROP SCHEMA` is currently unsupported
Delete a table	✓	`DROP TABLE` Documentation
Delete a view	✓	`DROP VIEW` Documentation

System Catalogs

The Postgres system catalogs is the schema pg_catalog which includes tables with information about the metadata of objects in the database. We support read only operations on the following pg_catalog tables:

Table	Description	Operations	Documentation
`pg_attribute`	stores information about a table's columns	read only	`pg_attribute` Documentation
`pg_class`	stores information about tables and views	read only	`pg_class` Documentation
`pg_namespace`	stores information about repositories	read only	`pg_namespace` Documentation
`pg_tables`	stores information about tables	read only	`pg_tables` Documentation
`pg_views`	stores information about views	read only	`pg_views` Documentation

The Information Schema

The information_schema schema contains views documenting the metadata about database objects according to the SQL standard. We support read-only operations on the following information_schema views:

View	Description	Operations	Documentation
`schemata`	stores information about repositories	read only	`information_schema.schemata` Documentation
`tables`	stores information about tables	read only	`information_schema.tables` Documentation
`columns`	stores information about repositories	read only	`information_schema.columns` Documentation
`views`	stores information about views	read only	`information_schema.views` Documentation

SQL Identifiers

Identifiers are tokens that identify the name of repositories, tables, columns, and views. We support the following types of identifiers:

Type	Supported	Documentation
Unquoted Identifiers	✓	`Unquoted Identifiers Documentation`
Quoted Identifiers	✓	`Quoted Identifiers Documentation`
Unicode Identifiers	✓	`Unicode Identifiers Documentation`

bit.io

The bit.io Developer Hub

Supported SQL Reference

📘

SQL Statements

SQL Types

Schema Definitions

System Catalogs

The Information Schema

SQL Identifiers

Supported SQL Reference

Suggested Edits are limited on API Reference Pages