Re: [SQL] join question - requesting for a simple C program where it can INSERT data into database as reference

intf("%-15s", PQgetvalue(res, i, j)); printf("\n"); } PQclear(res); res = PQexec(conn, "CLOSE mycursor"); PQclear(res); res = PQexec(conn, "COMMIT"); PQclear(res); PQfinish(conn); return 0; } Thanks, joo ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

[SQL] how to add primary key to existing table with multiple primary keys

Hi there,   I am trying to add another primary key to an existing table with two other primary keys.  I got the following error when I tried this command:   alter table extprobe2tissue ADD primary key (expid); ERROR:  multiple primary keys for table "extprobe2tissue" are not allowed  

[SQL] viewing the description of tables from python DB-API

Hi all,   Is there a way to view the list of all tables from python (or any other languages for that matter) DB-API?  What I’m looking for is a command similar to the meta-command ‘\d’ that works with the psql client.    Thanks very much!   Dan