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:
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.
- On this page
- Using PGFS with SQL
Could this page be better? Report a problem or suggest an addition!