Postgres Pro
Downloads
Home   >   mailing lists

Thread: attn.: psycopg users -- simple question

attn.: psycopg users -- simple question

From
Scott Frankel
Date:
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

Re: attn.: psycopg users -- simple question

From
Scott Frankel
Date:
Ack!  I sent this msg on October 14.  Since then, I've gotten the
primary
key stuff working.

Please disregard this msg.

Thanks
Scott




On Oct 14, 2004, at 4:16 PM, Scott Frankel wrote:

>
> 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
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>    (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>