Send feedback
Connect psycopg2 to a PostgreSQL-dialect database
Stay organized with collections
Save and categorize content based on your preferences.
This page explains how to connect the PostgreSQL psycopg2 driver to a PostgreSQL-dialect database
in Spanner. psycopg2
is a Python driver for PostgreSQL.
Ensure that PGAdapter is running on the same machine as the
application that is connecting using the PostgreSQL psycopg2 driver.
For more information, see Start PGAdapter .
Specify localhost
and 5432
as the database server host and port in the
psycopg2
connection properties.
Optionally specify a different port number if PGAdapter is
configured to listen on a port other than the default PostgreSQL
port (5432).
Optionally specify a different host name if PGAdapter is running
on a different host than the local machine.
connection = psycopg2 . connect ( database = "database_name " ,
host = "localhost" ,
port = 5432 )
cursor = connection . cursor ()
cursor . execute ( 'select \' Hello World \' ' )
for row in cursor :
print ( row )
cursor . close ()
connection . close ()
What's next
Send feedback
Except as otherwise noted, the content of this page is licensed under the Creative Commons Attribution 4.0 License , and code samples are licensed under the Apache 2.0 License . For details, see the Google Developers Site Policies . Java is a registered trademark of Oracle and/or its affiliates.
Last updated 2024-09-19 UTC.
[{
"type": "thumb-down",
"id": "hardToUnderstand",
"label":"Hard to understand"
},{
"type": "thumb-down",
"id": "incorrectInformationOrSampleCode",
"label":"Incorrect information or sample code"
},{
"type": "thumb-down",
"id": "missingTheInformationSamplesINeed",
"label":"Missing the information/samples I need"
},{
"type": "thumb-down",
"id": "otherDown",
"label":"Other"
}]
[{
"type": "thumb-up",
"id": "easyToUnderstand",
"label":"Easy to understand"
},{
"type": "thumb-up",
"id": "solvedMyProblem",
"label":"Solved my problem"
},{
"type": "thumb-up",
"id": "otherUp",
"label":"Other"
}]
Need to tell us more?
{"lastModified": "Last updated 2024-09-19 UTC."}
[[["Easy to understand","easyToUnderstand","thumb-up"],["Solved my problem","solvedMyProblem","thumb-up"],["Other","otherUp","thumb-up"]],[["Hard to understand","hardToUnderstand","thumb-down"],["Incorrect information or sample code","incorrectInformationOrSampleCode","thumb-down"],["Missing the information/samples I need","missingTheInformationSamplesINeed","thumb-down"],["Other","otherDown","thumb-down"]],["Last updated 2024-09-19 UTC."]]