Devart Forums

Hi

Someone know how to get the primary key fields from a postgres table?

Im working with Delphi XE2 and XE4, DbExpress DevArtPostgres Driver.

I try with

SqlQuery1.SetSchemaInfo(stIndexes,'MyTable','');
SqlQuery1.Open;

But return a list of indexnames, but not the Primary Key Fields.

Thanks.

Hello,

We cannot reproduce the problem - when executing the provided code, PK is returned correctly. Please specify your driver version and provide the script for creating the table.