[[["容易理解","easyToUnderstand","thumb-up"],["確實解決了我的問題","solvedMyProblem","thumb-up"],["其他","otherUp","thumb-up"]],[["難以理解","hardToUnderstand","thumb-down"],["資訊或程式碼範例有誤","incorrectInformationOrSampleCode","thumb-down"],["缺少我需要的資訊/範例","missingTheInformationSamplesINeed","thumb-down"],["翻譯問題","translationIssue","thumb-down"],["其他","otherDown","thumb-down"]],["上次更新時間:2025-09-05 (世界標準時間)。"],[],[],null,["# Connect psycopg2 to a PostgreSQL-dialect database\n\nThis page explains how to connect the PostgreSQL psycopg2 driver to a\nPostgreSQL-dialect database in Spanner. `psycopg2` is a Python\ndriver for PostgreSQL.\n\nVerify that PGAdapter is running on the same machine as the\napplication that is connecting using the PostgreSQL psycopg2 driver.\n\nFor more information, see [Start PGAdapter](/spanner/docs/pgadapter-start). \n\n connection = psycopg2.connect(database=\"\u003cvar translate=\"no\"\u003eDATABASE_NAME\u003c/var\u003e\",\n host=\"\u003cvar translate=\"no\"\u003eAPPLICATION_HOST\u003c/var\u003e\",\n port=\u003cvar translate=\"no\"\u003e\u003cspan class=\"devsite-syntax-nx\"\u003ePORT\u003c/span\u003e\u003c/var\u003e)\n\n cursor = connection.cursor()\n cursor.execute('select \\'Hello World\\'')\n for row in cursor:\n print(row)\n\n cursor.close()\n connection.close()\n\nReplace the following:\n\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\n### Unix domain sockets\n\nThis section explains how to use Unix domain sockets to connect to a\nPostgreSQL-dialect database database. Use Unix domain socket connections when you need to have\nthe lowest possible latency.\n\nTo use Unix domain sockets, PGAdapter must be running on the\nsame host as the client application. \n\n connection = psycopg2.connect(database=\"\u003cvar translate=\"no\"\u003eDATABASE_NAME\u003c/var\u003e\",\n host=\"\u003cvar translate=\"no\"\u003e/tmp\u003c/var\u003e\",\n port=\u003cvar translate=\"no\"\u003e\u003cspan class=\"devsite-syntax-n\"\u003ePORT\u003c/span\u003e\u003c/var\u003e)\n\n cursor = connection.cursor()\n cursor.execute('select \\'Hello World\\'')\n for row in cursor:\n print(row)\n\n cursor.close()\n connection.close()\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 psycopg2 driver connection options, see [psycopg2 Connection Options](https://github.com/GoogleCloudPlatform/pgadapter/blob/postgresql-dialect/docs/psycopg2.md) in the PGAdapter GitHub repository."]]