Welcome to postgresql’s documentation!

Indices and tables

• Index

• Module Index

• Search Page

PostgresqlConnect

Connect to PostgreSQL database

class postgresql.conn.PostgresqlConnect(host='localhost', user='sinnud', password='Jeffery45!@', database='dbhuge')

Bases: object

class PostgresqlConnect to connect to postgresql database

Parameters

• host – postgresql host name (ip address)

• user – user name in postgresql database

• password – user password in postgresql database

• database – the database name you like to connect

close()

connect()

connect to database: method for PostgresqlConnect

cursor()

get cursor of connection to database

execute(query)

ubmit query to database

Parameters

query – string of query you like to submit

postgresql.conn.main(arg=None)

test function

PostgresqlUtils

class postgresql.utils.PostgresqlUtils(host='localhost', user='sinnud', password='Jeffery45!@', database='dbhuge')

Bases: object

create_table(tbl=None, tbl_str=None, distby=None)

create_truncate_table(tbl=None, tbl_str=None, distby=None)

import_datalist(datalist=None, tbl=None, tbl_str=None, distby=None, headerline=False)

local_import(query, file)

table_exist(tbl=None)

truncate_table(tbl=None)

postgresql.utils.main(arg=None)