Hi Fabian, Thanks this has been incredibly useful. Djonet can now also do database introspection and reverse engineer the database schema for Django. -- Gijs Molenaar http://www.astro.uva.nl/people/gijs-molenaar/ On Jun 14, 2012, at 12:32 PM, Fabian Groffen wrote: Gijs, On 14-06-2012 10:27:13 +0000, Molenaar, Gijs wrote: I have the same problem for finding out which field is the primary key. I now have: select k.name as key, t.name as tablename from sys.keys as k, sys.tables as t where k.type=0 and k.table_id = t.id; Should I stringparse the key field for finding out the column name? Perhaps you can "borrow" some code from JDBC and clients/mapiclient/dump.c Fabian ------------------------------------------------------------------------------ Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers can respond. Discussions will include endpoint security, mobile security and the latest in malware threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/___________________... MonetDB-users mailing list MonetDB-users@lists.sourceforge.netmailto:MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users