[fpc-pascal] GetTableNames in TSQLConnection / Postgresql

[LacaK]

For now I added in rev.23163 schema name into query for PostgreSQL (so 
no empty schema name is returned, but valid schema name)
Here I understand:
stTables - list of all tables, which may include system tables (it is 
not clear from documentation)?
stSysTables - list of ONLY system tables (not views)

http://docwiki.embarcadero.com/Libraries/XE2/en/Data.SqlExpr.TSQLConnection.GetTableNames
"If SystemTables is true, only the system tables are added to List. If 
SystemTables is false, the list is filled with any tables that match the 
criteria specified by the TableScope 
<http://docwiki.embarcadero.com/Libraries/XE2/en/Data.SqlExpr.TSQLConnection.TableScope> 
property"


http://docwiki.embarcadero.com/Libraries/XE2/en/Data.SqlExpr.TCustomSQLDataSet.SetSchemaInfo

"stTables -  Information about all the data tables on the database 
server that match the criteria specified by the SQL connection's 
TableScope 
<http://docwiki.embarcadero.com/Libraries/XE2/en/Data.SqlExpr.TSQLConnection.TableScope> 
property."

"stSysTables - Information about all of the system tables on the 
database server"

"If an application calls GetTablesNames with SystemTables set to true, 
or calls SetSchemaInfo 
<http://docwiki.embarcadero.com/Libraries/XE2/en/Data.SqlExpr.TCustomSQLDataSet.SetSchemaInfo> 
with SchemaType set to stSysTables, system tables, and only system 
tables are returned, regardless of the value of *TableScope*."

-Laco.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freepascal.org/pipermail/fpc-pascal/attachments/20121217/25331727/attachment.html>