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.net
https://lists.sourceforge.net/lists/listinfo/monetdb-users