On Tue, December 18, 2012 14:34, John wrote: > On 12/18/2012 07:35 PM, michael.vancann...@wisa.be wrote: > > <snip> > >> 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 Postgres, it IS optional, in the sense that you can > make all your tables in the "public" schema, in which case you don't > need to specify the schema to access them, but if you make them in any > other schema, you must specify it in the query. (And yes, I have only > just found that out, by experiment. Coming from an Oracle background, I > just always made schemas for my tables.)
>From this point of view, the schema prefix is "optional" with Oracle too (using public synonyms), but that is not a generally applicable solution. Tomas _______________________________________________ fpc-pascal maillist - fpc-pascal@lists.freepascal.org http://lists.freepascal.org/mailman/listinfo/fpc-pascal