Suppressing public. in tables names

From: "Paul Cochrane" <paul(at)tortc(dot)tuht(dot)scot(dot)nhs(dot)uk>
To: pgsql-odbc(at)postgresql(dot)org
Subject: Suppressing public. in tables names
Date: 2003-09-03 10:39:23
Message-ID: 3F55D2A7.14621.1A007BC0@localhost
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

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???????

-------------------------------------
Paul Cochrane | Tayside Orthopaedic & |
| Rehabilitation Technology Centre |
============= |-------------------------------------|
| Ninewells Hospital & Med. School |
| Dundee, Scotland, UK. |
| DD1 9SY. |
| Phone: +44 1382 496284 |
| Fax: +44 1382 496322 |
| E-Mail: paul(at)tortc(dot)tuht(dot)scot(dot)nhs(dot)uk |
-------------------------------------

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Michael James 2003-09-03 18:02:47 Inquiry From Form [pgsql]
Previous Message Chris Gamache 2003-09-02 15:17:10 Re: ODBC Connection Pooling (Windows 2000 MDAC 2.7 patched, pgodbc-7.02.00.05)