Connect to an existing PostgreSQL instance and extract data. Rows of data in PostgreSQL are extracted as JSON objects.

Supports common implementations of PostgreSQL including Supabase

Properties

Required properties:

  • connection_string: Connection string to the Postgres instance
  • query: SQL query to extract data (i.e. Select * From TableName)

Optional properties:

  • batch_size: The size of batches of rows. Affects performance and latency.

Compatible loaders:

  • NeumJSONLoader

Usage