name of primary key column for given table ?

madrazel

All I know is the pragma statement, but I can't make a correct select statement against it:

select name from pragma table_info(tblname) where pk=1

- returns error

Weedpacket

¿Que?

bradgrafelman

Weedpacket wrote:
¿Que?

¿Qué? :p

@: Might want to tell us which database you're using, since the syntax/procedure for doing this is most likely going to vary from one DBMS to the next.

EDIT: Might also want to copy and paste the exact error message, too, just in case it helps.

madrazel

Sorry, my bad. I'm using sqlite.

And this is my solution:

$tableid = preg_match("|CREATE TABLE \"$tbl\" [(] (?<id>\w+) INTEGER PRIMARY KEY ON CONFLICT IGNORE,|",$pdo->query("select sql from sqlite_master where tbl_name='$tbl'")->fetchColumn(),$id) ? $id['id'] : exit("upsanerr: $id, $tbl");

Weedpacket

bradgrafelman wrote:
¿Qué? :p

Oh, don't mind me; I'm from Barcelona.

@, I don't have a SQLite installation handy right now, but I recall it does have a set of Information Schema views. If I'm right, then

SELECT kcu.column_name FROM INFORMATION_SCHEMA_KEY_COLUMN_USAGE kcu, INFORMATION_SCHEMA_TABLES t
JOIN kcu.constraint_name=t.constraint_name WHERE t.table_name='$tbl'

Or something not too different from that.