Re: Is it possible to remove the public schema?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Henry Combrinck" <henry(at)metroweb(dot)co(dot)za>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Is it possible to remove the public schema?
Date: 2004-10-21 16:07:58
Message-ID: 16216.1098374878@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Henry Combrinck" <henry(at)metroweb(dot)co(dot)za> writes:
> I've been approached by the development people about removing the 'public'
> schema. They complain about having to manually remove the 'public_' tag
> from table names generated by their development software whenever they
> link to PG via ODBC.

> Renaming or using another schema is not what they're after either.

Hmm ... you can certainly drop the public schema if you want, but that
just means that you have to put your tables into some other schema.

It sounds to me like the real problem is with non-schema-aware client
software. I think your options are to fix that, or downgrade to a
non-schema-aware database (eg. Postgres 7.2 or before).

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jan Wieck 2004-10-21 17:03:01 Re: Information about storge engine in PostgreSQL
Previous Message Karsten Hilbert 2004-10-21 15:40:53 Re: Information about storge engine in PostgreSQL