How to access a PostgreSQL database?
jilderda at dds.nl
Sun Aug 10 12:47:32 CEST 2003
question on accessing databases:
I'm trying to build a script  to archive messages from a mailinglist
into a GForge  server's web forums. Effectively, this provides us
with a central means of communication that can be accessed via web,
mail, and news. GForge uses mailman and postgresql.
It seemed a good idea to use the DB-API spec v2.0 with the PyGreSQL
library but I can't seem to find any decent documentation or examples
and am starting to run out of patience with the 'trial on error'
approach. Hopefully somebody can point me in the right direction. :-)
A couple of questions:
- What is the most elegant way to connect to a database? I had expected
by instantiating a db class which has a 'connect' method but can't
find it. Currently, this is how I do it (which works):
# connect to database
connection = pgdb.connect(host = 'localhost', user = 'postgres', \
database = 'alexandria')
cursor = connection.cursor()
- How on Earth can I insert a tuple into a table with the proper types?
I tried 'cursor.execute()' but keep running into typing issues. (At
the bottom of this post, I included the table's layout.
Any help is appreciated,
1. See attachment, bear in mind there are some ugly shortcuts in
The table 'forum' looks as follows (cut & paste from 'psql'):
alexandria=# \d forum
Column | Type | Modifiers
msg_id | integer | not null default
group_forum_id | integer | not null default '0'
posted_by | integer | not null default '0'
subject | text | not null default ''
body | text | not null default ''
date | integer | not null default '0'
is_followup_to | integer | not null default '0'
thread_id | integer | not null default '0'
has_followups | integer | default '0'
most_recent_date | integer | not null default '0'
Indexes: forum_pkey primary key btree (msg_id),
forum_forumid_isfollto_mostrece btree (group_forum_id,
forum_forumid_msgid btree (group_forum_id, msg_id),
forum_forumid_threadid_mostrece btree (group_forum_id,
forum_group_forum_id btree (group_forum_id),
forum_threadid_isfollowupto btree (thread_id, is_followup_to)
-------------- next part --------------
An embedded and charset-unspecified text was scrubbed...
More information about the Python-list