Re: Suppressing public. in tables names
От | Mainlander |
---|---|
Тема | Re: Suppressing public. in tables names |
Дата | |
Msg-id | MPG.19d8120fd8052424989680@news.postgresql.org обсуждение исходный текст |
Ответ на | Suppressing public. in tables names ("Paul Cochrane" <paul@tortc.tuht.scot.nhs.uk>) |
Список | pgsql-odbc |
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.
В списке pgsql-odbc по дате отправления: