[fpc-pascal] sqldb how to find a record fast with primary key

[Felipe Monteiro de Carvalho]

Hello,

I am using sqldb to connect to a postgres database. Using wiki
instructions, my final object is a TSQLQuery for each table. So, this
basically is a TDataset and to read fields I know that I can use
First(), Next(), EOF() and RecNo

But these are rather slow. Many fields in the tables refer to the
primary key in other tables, which does not match the RecNo. How can I
jump fast a table to the record which has a particular PrimaryKey?

thanks,
-- 
Felipe Monteiro de Carvalho