const{Client}=require('pg');constclient=newClient({host:'APPLICATION_HOST',port:PORT,database:'DATABASE_NAME',});awaitclient.connect();constres=awaitclient.query("select 'Hello world!' as hello");console.log(res.rows[0].hello);awaitclient.end();
替换以下内容:
APPLICATION_HOST:运行 PGAdapter 的机器的主机名或 IP 地址。如果在本地运行,您可以使用 localhost。
constclient=newClient({host:'/tmp',port:PORT,database:'DATABASE_NAME',});awaitclient.connect();constres=awaitclient.query("select 'Hello world!' as hello");console.log(res.rows[0].hello);awaitclient.end();
[[["易于理解","easyToUnderstand","thumb-up"],["解决了我的问题","solvedMyProblem","thumb-up"],["其他","otherUp","thumb-up"]],[["很难理解","hardToUnderstand","thumb-down"],["信息或示例代码不正确","incorrectInformationOrSampleCode","thumb-down"],["没有我需要的信息/示例","missingTheInformationSamplesINeed","thumb-down"],["翻译问题","translationIssue","thumb-down"],["其他","otherDown","thumb-down"]],["最后更新时间 (UTC):2025-08-26。"],[],[],null,["# Connect node-postgres to a PostgreSQL-dialect database\n\nThis page explains how to connect the PostgreSQL node-postgres driver to a\nPostgreSQL-dialect database in Spanner. node-postgres is a Node.js\ndriver for PostgreSQL.\n\n1. Verify that PGAdapter is running on the same machine as the\n application that is connecting using the PostgreSQL node-postgres driver.\n\n For more information, see [Start PGAdapter](/spanner/docs/pgadapter-start).\n2. Specify the database server host and port in the\n `node-postgres` connection properties:\n\n const { Client } = require('pg');\n const client = new Client({\n host: '\u003cvar translate=\"no\"\u003eAPPLICATION_HOST\u003c/var\u003e',\n port: \u003cvar translate=\"no\"\u003e\u003cspan class=\"devsite-syntax-kt\"\u003ePORT\u003c/span\u003e\u003c/var\u003e,\n database: '\u003cvar translate=\"no\"\u003eDATABASE_NAME\u003c/var\u003e',\n });\n await client.connect();\n const res = await client.query(\"select 'Hello world!' as hello\");\n console.log(res.rows[0].hello);\n await client.end();\n\n Replace the following:\n - \u003cvar translate=\"no\"\u003eAPPLICATION_HOST\u003c/var\u003e: the hostname or IP address of the machine where PGAdapter is running. If running locally, you can use `localhost`.\n - \u003cvar translate=\"no\"\u003ePORT\u003c/var\u003e: the port number where PGAdapter is running. Change this in the connection string if PGAdapter is running on a custom port. Otherwise, use the default port, `5432`.\n\nUnix domain sockets\n-------------------\n\nThis section explains how to use Unix domain sockets to connect a\nPostgreSQL node-postgres driver to a PostgreSQL-dialect database. Use Unix domain socket\nconnections when you need to have the lowest possible latency.\n\nTo use Unix domain sockets, PGAdapter must be running on the\nsame host as the client application. \n\n const client = new Client({\n host: '\u003cvar translate=\"no\"\u003e/tmp\u003c/var\u003e',\n port: \u003cvar translate=\"no\"\u003e\u003cspan class=\"devsite-syntax-kt\"\u003ePORT\u003c/span\u003e\u003c/var\u003e,\n database: '\u003cvar translate=\"no\"\u003eDATABASE_NAME\u003c/var\u003e',\n });\n await client.connect();\n const res = await client.query(\"select 'Hello world!' as hello\");\n console.log(res.rows[0].hello);\n await client.end();\n\nReplace the following:\n\n- \u003cvar translate=\"no\"\u003e/tmp\u003c/var\u003e: the default domain socket directory for PGAdapter. This can be changed using the `-dir` command line argument.\n- \u003cvar translate=\"no\"\u003ePORT\u003c/var\u003e: the port number where PGAdapter is running. Change this in the connection string if PGAdapter is running on a custom port. Otherwise, use the default port, `5432`.\n\nWhat's next\n-----------\n\n- Learn more about [PGAdapter](/spanner/docs/pgadapter).\n- For more information about PostgreSQL node-postgres driver connection options, see [node-postgres Connection\n Options](https://github.com/GoogleCloudPlatform/pgadapter/blob/-/docs/node-postgres.md) in the PGAdapter GitHub repository."]]