In article <3F55D2A7.14621.1A007BC0@localhost>,
paul@tortc.tuht.scot.nhs.uk says...
> A while back (January) I asked a question about using Borlands
> BDE to access a postgres database via ODBC. In Postgres 7.3, the
> table names returned to the application always have the format
> 'public.tablename'.
>
> Using postgres 7.2, the table name returned to the application is
> simply 'tablename'.
>
> What I'd like to know is that is there / could there be a setting in the
> odbc driver to allow the suppression of the 'public.' schema when
> returning a table name? Possibly an option to ignore schemas
> entirely or make them blank?
>
> I've tried setting the search_path to just 'public' & blank with no
> success.
>
> If this can't be sorted or worked around it looks like I'm gonna be
> stuck on 7.2 forever....
>
> Is there any hope???????
What is the problem?
When I run my queries with the existing table names they work exactly as
they did before, without having to change table names to have "public."
in front of them.