On Mon, 23 Jul 2001, dado feigenblatt wrote:
> > system tables all ~ '^pg', which is probably a better check than
> > user=postgresql.
>
> You never know when someone will name their tables starting with "pg".
> Well, you never know when someone will create their tables as user postgres
> either.
You probably want to check for '^pg_' since you shouldn't be able to
create user table names starting with pg_. As the administrator on my
home test system:
sszabo=> create table "pg_a"(A int);
ERROR: Illegal class name 'pg_a'
The 'pg_' name prefix is reserved for system catalogs
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://www.postgresql.org/search.mpl
