Goose Environment

Goose provides a number of functions and PRAGMA options to retrieve information on the running Goose instance and its environment.

Version

The version() function returns the version number of Goose.

SELECT version() AS version;

version
v{{ site.0.6.2

Using a PRAGMA:

PRAGMA version;

library_version	source_id
v0.6.2	xxx

Platform

The platform information consists of the operating system, system architecture, and, optionally, the compiler. The platform is used when installing extensions. To retrieve the platform, use the following PRAGMA:

PRAGMA platform;

On macOS, running on Apple Silicon architecture, the result is:

platform
osx_arm64

On Windows, running on an AMD64 architecture, the platform is windows_amd64. On Ubuntu Linux, running on the ARM64 architecture, the platform is linux_arm64.

Extensions

To get a list of Goose extensions and their status (e.g., loaded, installed), use the goose_extensions() function:

SELECT *
FROM goose_extensions();

Meta Table Functions

Goose has the following built-in table functions to obtain metadata about available catalog objects:

• goose_columns(): columns
• goose_constraints(): constraints
• goose_databases(): lists the databases that are accessible from within the current Goose process
• goose_dependencies(): dependencies between objects
• goose_extensions(): extensions
• goose_functions(): functions
• goose_indexes(): secondary indexes
• goose_keywords(): Goose's keywords and reserved words
• goose_optimizers(): the available optimization rules in the Goose instance
• goose_schemas(): schemas
• goose_sequences(): sequences
• goose_settings(): settings
• goose_tables(): base tables
• goose_temporary_files(): the temporary files Goose has written to disk, to offload data from memory
• goose_types(): data types
• goose_views(): views