[fpc-pascal] GetTableNames in TSQLConnection / Postgresql

Michael Van Canneyt michael at freepascal.org
Sun Dec 16 14:55:12 CET 2012



On Sun, 16 Dec 2012, Reinier Olislagers wrote:

> On 16-12-2012 2:27, John wrote:
>> @Reinier:
>>>> Analysis:
>>>> As far as I can work out, a call to GetTableNames calls GetDBInfo, with
>>>> parameters
>>>>    ASchemaType : TSchemaType - This specifies what info we want - user
>>>> tables, sys tables, procedures, columns etc
>>>>    ASchemaObjectName - Doesn't seem to be used, it is specified as ""
>>> No, it's not used for GetTableNames; it is used e.g. to specify the
>>> table name if you want to know info about columns.
>> Yes, I saw that, but there seems no reason why it could not be used as a
>> schema selection.
> I understand; just wanted to let you know what it was used for.
>
>> I also had a flip through the previous discussion, but it was indeed a
>> long and tortuous thread to follow!
> Agreed. AFAIR, there was a decision in the end... but it was a long
> thread and a long while ago.
> I've incorporated some of Lacak's proposal into
> http://wiki.lazarus.freepascal.org/Database_metadata#Proposal_for_extension.2Funiformization
> ... and will update that page going through that thread.
> If anybody gets to it earlier, please feel free to update the page ;)

It would be good to add a link to the 'standard sql' referred to ?

Michael.



More information about the fpc-pascal mailing list