PGFS SQL in Pipelines

Note

This feature is available in EDB Postgres AI - AI Accelerator Pipelines. We recommend you use the functionality of the pgfs functions to configure a storage location.

Using PGFS with SQL

Using the CREATE SERVER command

You can also use the CREATE SERVER command to create a server object that connects to the storage location. You can then create a foreign table that is associated with the server.

Here is an example of creating a server object that connects to an S3-compatible bucket:

CREATE SERVER my_server FOREIGN DATA WRAPPER pgfs OPTIONS (url 's3://my_bucket');

Options and Credentials

There are various options and credentials that you can pass to the storage locations. The options and credentials are specific to the type of storage location you are using.

local file storage

How to use Pipelines PGFS with local file storage.

S3 storage

PGFS options and credentials with S3-compatible storage.


Could this page be better? Report a problem or suggest an addition!