Statements

📄️ ANALYZE Statement

The ANALYZE statement recomputes the statistics on Goose's tables.

📄️ ALTER TABLE Statement

The ALTER TABLE statement changes the schema of an existing table in the catalog.

📄️ ALTER VIEW Statement

The ALTER VIEW statement changes the schema of an existing view in the catalog.

📄️ ATTACH and DETACH Statements

Goose allows attaching to and detaching from database files.

📄️ CALL Statement

The CALL statement invokes the given table function and returns the results.

📄️ CHECKPOINT Statement

The CHECKPOINT statement synchronizes data in the write-ahead log (WAL) to the database data file.

📄️ COMMENT ON Statement

The COMMENT ON statement allows adding metadata to catalog entries (tables, columns, etc.).

📄️ CREATE MACRO Statement

The CREATE MACRO statement can create a scalar or table macro (function) in the catalog.

📄️ CREATE SCHEMA Statement

The CREATE SCHEMA statement creates a schema in the catalog. The default schema is main.

📄️ CREATE SECRET Statement

The CREATE SECRET statement creates a new secret in the Secrets Manager.

📄️ CREATE SEQUENCE Statement

The CREATE SEQUENCE statement creates a new sequence number generator.

📄️ CREATE TYPE Statement

The CREATE TYPE statement defines a new type in the catalog.

📄️ CREATE VIEW Statement

The CREATE VIEW statement defines a new view in the catalog.

📄️ CREATE TABLE Statement

The CREATE TABLE statement creates a table in the catalog.

📄️ DELETE Statement

The DELETE statement removes rows from the table identified by the table-name.

📄️ DESCRIBE Statement

The DESCRIBE statement shows the schema of a table, view or query.

📄️ DROP Statement

The DROP statement removes a catalog entry added previously with the CREATE command.

📄️ EXPORT and IMPORT DATABASE Statements

The EXPORT DATABASE command allows you to export the contents of the database to a specific directory. The IMPORT DATABASE command allows you to then read the contents again.

📄️ INSERT Statement

The INSERT statement inserts new data into a table.

The MERGE INTO statement is an alternative to INSERT INTO ... ON CONFLICT that doesn't need a primary key since it allows for a custom match condition. This is a very useful alternative for upserting use cases (INSERT + UPDATE) when the destination table does not have a primary key constraint.