Documentation → PostgreSQL 7.3

Unsupported versions: 7.3 / 7.2 / 7.1

This documentation is for an unsupported version of PostgreSQL.
You may want to view the same page for the current version, or one of the other supported versions listed above instead.

PostgreSQL 7.3.21 Documentation
Prev		Next

connect

Name

connect -- open a connection to the database server

Synopsis

connect([dbname], [host], [port], [opt], [tty], [user], [passwd])

Parameters

dbname: Name of connected database (string/None).
host: Name of the server host (string/None).
port: Port used by the database server (integer/-1).
opt: Options for the server (string/None).
tty: File or tty for optional debug output from backend (string/None).
user: PostgreSQL user (string/None).
passwd: Password for user (string/None).

Return Type

pgobject: If successful, an object handling a database connection is returned.

Exceptions

TypeError: Bad argument type, or too many arguments.
SyntaxError: Duplicate argument definition.
pg.error: Some error occurred during pg connection definition.

(plus all exceptions relative to object allocation)

Description

This method opens a connection to a specified database on a given PostgreSQL server. You can use key words here, as described in the Python tutorial. The names of the key words are the name of the parameters given in the syntax line. For a precise description of the parameters, please refer to the PostgreSQL user manual.

Examples

import pg

con1 = pg.connect('testdb', 'myhost', 5432, None, None, 'bob', None)
con2 = pg.connect(dbname='testdb', host='localhost', user='bob')

Prev	Home	Next
`pg` Module Functions	Up	get_defhost