select open change scope Open full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

Extensions / Utilities

external_file

Access external server-side files through PostgreSQL functions

pgext.cloud · Source code · License text · Control file

Overview

Packageexternal_file
Version1.2
PostgreSQL versions14 · 15 · 16 · 17 · 18
RepositoryPIGSTY
Extension typeSQL only
Requires CREATE EXTENSIONYes
Requires preloadNo
TrustedNo
RelocatableNo
Schemaexternal_file
Stars41
Latest commit2025-05-02
Latest release2025-05-02
Catalogue updated2026-08-30

Related extensions

See also

fioPostgreSQL File I/O Functions
floatfileSimple file storage for arrays of floats
file_fdwforeign-data wrapper for flat file access
byteamagicDetect MIME types and file formats from PostgreSQL bytea values
aws_s3aws_s3 postgres extension to import/export data from/to s3
envvarFetch the value of an environment variable
pg_bulkloadpg_bulkload is a high speed data loading utility for PostgreSQL
basic_archivean example of an archive module
basebackup_to_shelladds a custom basebackup target called shell
pg_parquetcopy data between Postgres and Parquet