Re: Suppressing public. in tables names

In article <3F55D2A7(dot)14621(dot)1A007BC0(at)localhost>,
paul(at)tortc(dot)tuht(dot)scot(dot)nhs(dot)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.