class PostgresLoaderGoogle Cloud SQL for PostgreSQL vector store integration.
Setup:
Install@langchain/google-cloud-sql-pg
npm install @langchain/google-cloud-sql-pgimport { PostgresEngine, PostgresLoader } from "@langchain/google-cloud-sql-pg";
const documentLoaderArgs: PostgresLoaderOptions = {
tableName: "test_table_custom",
contentColumns: [ "fruit_name", "variety"],
metadataColumns: ["fruit_id", "quantity_in_stock", "price_per_unit", "organic"],
format: "text"
};
const documentLoaderInstance = await PostgresLoader.initialize(PEInstance, documentLoaderArgs);
const documents = await documentLoaderInstance.load();import { PostgresEngine, PostgresLoader } from "@langchain/google-cloud-sql-pg";
const documentLoaderArgs: PostgresLoaderOptions = {
query: "SELECT * FROM my_table WHERE organic = true;",
contentColumns: [ "fruit_name", "variety"],
metadataColumns: ["fruit_id", "quantity_in_stock", "price_per_unit", "organic"],
format: "text"
};
const documentLoaderInstance = await PostgresLoader.initialize(PEInstance, documentLoaderArgs);
for await (const doc of documentLoaderInstance.lazyLoad()) {
console.log(doc);
break; // break based on required condition
}