attn.: psycopg users -- simple question

From: Scott Frankel <frankel(at)circlesfx(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: attn.: psycopg users -- simple question
Date: 2004-10-14 23:16:06
Message-ID: 06358EE4-1E37-11D9-AEEC-000A95A7B782@circlesfx.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


Sorry to burden this list (again) with a psycopg question.
I'm stuck at a table creation step and am not getting results
from their list.

Question: what's the appropriate syntax for specifying a primary
key?

My very simple table creation test (based on their "first.py"
example is failing ... Here's what I'm trying. Non-pythonated
syntax works in pgsql:

no go in psycopg:
curs.execute("""CREATE TABLE key_test (
key_col CHAR(9) PRIMARY KEY,
nother_col CHAR(256))""")

pure joy in pgsql:
cs_test=# CREATE TABLE key_test (
cs_test(# key_col CHAR(9) PRIMARY KEY,
cs_test(# nother_col CHAR(256)
cs_test(# );

Thanks again!
Scott

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Mark Dexter 2004-10-14 23:55:17 Complex Update Queries with Fromlist
Previous Message Luciano Bastianello 2004-10-14 21:28:58 R: Count Issues