Re: [fpc-pascal] GetTableNames in TSQLConnection / Postgresql

2012-12-21 Thread Tomas Hajny
On Tue, December 18, 2012 14:34, John wrote: > On 12/18/2012 07:35 PM, michael.vancann...@wisa.be wrote: > > > >> MySQL, Firebird, MS-access, sqlite simply do not have schema as Oracle >> has. In PostGres or MS-SQL it's optional, to my knowledge (not an >> expert). >> > > For the record, in Postgr

Re: [fpc-pascal] GetTableNames in TSQLConnection / Postgresql

2012-12-21 Thread Tomas Hajny
On Tue, December 18, 2012 09:35, michael.vancann...@wisa.be wrote: > On Tue, 18 Dec 2012, John wrote: > >>> TSchemaOption = (soPrependSchemaName,soIncludeSystemObjects); >>> TSchemaOptions = set of TSchemaOption; >>> >>> Procedure GetTableNames(List : TStrings; Options : TSchemaOptions = >>> []); >

[fpc-pascal] Re: GetTableNames in TSQLConnection / Postgresql

2012-12-21 Thread Reinier Olislagers
On 18-12-2012 10:49, Tomas Hajny wrote: > On Tue, December 18, 2012 09:35, > michael.vancanneyt-0is9kj9s...@public.gmane.org wrote: >> On Tue, 18 Dec 2012, John wrote: >>> you can't! That brings me back to the original point that either >>> gettablenames has to operate on a known schema only (so

Re: [fpc-pascal] Re: GetTableNames in TSQLConnection / Postgresql

2012-12-21 Thread Tomas Hajny
On Fri, December 21, 2012 11:59, Reinier Olislagers wrote: > On 18-12-2012 10:49, Tomas Hajny wrote: >> On Tue, December 18, 2012 09:35, >> michael.vancanneyt-0is9kj9s...@public.gmane.org wrote: >>> On Tue, 18 Dec 2012, John wrote: you can't! That brings me back to the original point that eit

Re: [fpc-pascal] Re: GetTableNames in TSQLConnection / Postgresql

2012-12-21 Thread John
On 12/21/2012 10:37 PM, Tomas Hajny wrote: On Fri, December 21, 2012 11:59, Reinier Olislagers wrote: On 18-12-2012 10:49, Tomas Hajny wrote: On Tue, December 18, 2012 09:35, michael.vancanneyt-0is9kj9s...@public.gmane.org wrote: On Tue, 18 Dec 2012, John wrote: you can't! That brings me bac

Re: [fpc-pascal] Re: GetTableNames in TSQLConnection / Postgresql

2012-12-21 Thread LacaK
John wrote / napĂ­sal(a): On 12/21/2012 10:37 PM, Tomas Hajny wrote: On Fri, December 21, 2012 11:59, Reinier Olislagers wrote: On 18-12-2012 10:49, Tomas Hajny wrote: On Tue, December 18, 2012 09:35, michael.vancanneyt-0is9kj9s...@public.gmane.org wrote: On Tue, 18 Dec 2012, John wrote: you