postgres connection check

Gani Vk answered on January 8, 2022 Popularity 9/10 Helpfulness 1/10

answer postgres connection check

related test the postgresql db connection

postgres connection check

Comment

from sqlalchemy import event
from sqlalchemy import create_engine

engine = create_engine("postgresql+psycopg2://scott:tiger@host/dbname")

@event.listens_for(engine, "connect", insert=True)
def set_search_path(dbapi_connection, connection_record):
    existing_autocommit = dbapi_connection.autocommit
    dbapi_connection.autocommit = True
    cursor = dbapi_connection.cursor()
    cursor.execute("SET SESSION search_path='%s'" % schema_name)
    cursor.close()
    dbapi_connection.autocommit = existing_autocommit

Popularity 9/10 Helpfulness 1/10 Language python

Source: docs.sqlalchemy.org

Tags: connection python

Link to this answer
Share Copy Link

Contributed on Apr 27 2022

Gani Vk

0 Answers Avg Quality 2/10

Closely Related Answers

test the postgresql db connection

Comment

psql -U kodekloud_aim -d kodekloud_db8 -h 127.0.0.1 -W  ## Change name according to question
#### for the test on mode postgres u have
## \conninfo 
## \l
## \dg+
## \q   # to quit
psql -U kodekloud_gem -d kodekloud_db10 -h localhost -W

Popularity 9/10 Helpfulness 5/10 Language sql

Source: gist.github.com

Tags: connection c

Link to this answer
Share Copy Link

Contributed on Jan 08 2022

Glamorous Giraffe

0 Answers Avg Quality 2/10

postgres connection check

Contents

More Related Answers

postgres connection check

Closely Related Answers

test the postgresql db connection

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.