[fpc-pascal] GetTableNames in TSQLConnection / Postgresql

[Reinier Olislagers]

On 16-12-2012 14:55, Michael Van Canneyt wrote:
> 
> 
> 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 ?
> 
Also, e.g. PostgreSQL and Mimer have very good documentation on what
these information_schema views contain.
I vaguely recall this was covered in our previous thread...