Pipelines reference - PGFS

This section provides reference documentation for EDB Postgres AI - AI Accelerator Pipelines PGFS. It includes information on the functions and views available in the pgfs extension that gives aidb access to S3-compatible file systems and local file systems.

pgfs

Functions

• pgfs.create_foreign_table
• pgfs.create_storage_location
• pgfs.create_storage_location_with_foreign_table
• pgfs.delete_storage_location
• pgfs.list_storage_locations
• pgfs.get_storage_location
• pgfs.update_storage_location

Functions

pgfs.create_foreign_table

Creates a foreign table in the database.

Parameters

Example

SELECT pgfs.create_foreign_table('my_table', 'my_server');

pgfs.create_storage_location

Creates a storage location in the database.

Parameters

Example

SELECT pgfs.create_storage_location('my_storage', 's3://my_bucket', '123e4567-e89b-12d3-a456-426614174000', '{}', '{}');

pgfs.create_storage_location_with_foreign_table

Creates a storage location in the database and associates it with a foreign table.

Parameters

Example

SELECT pgfs.create_storage_location_with_foreign_table('my_storage', 's3://my_bucket', '123e4567-e89b-12d3-a456-426614174000', '{}', '{}');

pgfs.delete_storage_location

Deletes a storage location from the database.

Parameters

Example

SELECT pgfs.delete_storage_location('my_storage');

pgfs.get_default_storage_location

Returns the default storage location.

Returns

Example

SELECT * FROM pgfs.get_default_storage_location();

pgfs.get_storage_location

Returns information about a storage location.

Parameters

Returns

Example

SELECT * FROM pgfs.get_storage_location('my_storage');

pgfs.list_storage_locations

Lists all storage locations in the database.

Returns

Example

SELECT * FROM pgfs.list_storage_locations();

pgfs.set_default_storage_location

Sets the default storage location.

Parameters

Example

SELECT pgfs.set_default_storage_location('my_storage');

pgfs.update_storage_location

Updates a storage location in the database.

Parameters

Example

SELECT pgfs.update_storage_location('my_storage', 's3://my_bucket', '123e4567-e89b-12d3-a456-426614174000', '{}', '{}');

Views

There are no user-facing views in the pgfs schema.

Tables

There are no user-facing tables in the pgfs schema.