select a column of type INTEGER PRIMARY KEY magically

[bartonc]

Is it possible to select a column of type INTEGER PRIMARY KEY without knowing its name? This also happens to be column zero in all my tables. I've played with lots of different syntaxes, to no avail. I was hoping for something compatible with SQLite like:

SELECT * FROM tablename WHERE  ROWID = n;
# or
SELECT * FROM tablename WHERE  _ROWID_ = n;
# or
SELECT * FROM tablename WHERE  OID = n;

Thanks, all.

[debasisdas]

Are you trying to refer to the column without knowing its name.

[r035198x]

I've see this used before somewhere but I haven't tried it myself

SELECT k.column_name
FROM information_schema.table_constraints t
JOIN information_schema.key_column_usage k
USING(constraint_name,table_schema,table_name)
WHERE t.constraint_type='PRIMARY KEY'
  AND t.table_schema='yourdatabase'
  AND t.table_name='yourtable';

[bartonc]

I've see this used before somewhere but I haven't tried it myself

SELECT k.column_name
FROM information_schema.table_constraints t
JOIN information_schema.key_column_usage k
USING(constraint_name,table_schema,table_name)
WHERE t.constraint_type='PRIMARY KEY'
  AND t.table_schema='yourdatabase'
  AND t.table_name='yourtable';

Awesome! Thank you very much.