Skip site navigation (1) Skip section navigation (2)

Re: schemas (public, custom...)

From: "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk>
To: "Reshat Sabiq" <sabiq(at)purdue(dot)edu>,<pgadmin-support(at)postgresql(dot)org>
Subject: Re: schemas (public, custom...)
Date: 2002-12-22 19:21:33
Message-ID: 03AF4E498C591348A42FC93DEA9661B88535@mail.vale-housing.co.uk (view raw or flat)
Thread:
Lists: pgadmin-support

> -----Original Message-----
> From: Reshat Sabiq [mailto:sabiq(at)purdue(dot)edu] 
> Sent: 22 December 2002 14:52
> To: pgadmin-support(at)postgresql(dot)org
> Subject: [pgadmin-support] schemas (public, custom...)
> 
> 
> What is the significance of public schema (for migration and 
> otherwise). Is it optional to select a schema? I believe it 
> is for security constraints. I'm just not used to working 
> with SQL statements like: public."TableName" What schema 
> should I have for a DB that will be on the web mostly for 
> queries? In the short term, I might be connecting to it 
> remotely, but in the long term I should have 
> add/update/delete interface on the web (running as me via 
> JDBC). Should I keep it public, none at all, or make a custom one? 

If you have PostgreSQL 7.2.x or below, then the public schema in pgAdmin
doesn't really exist, it's just a dummy for compatibility with
PostgreSQL 7.3. If you have 7.3.x, then you must use a schema. If you
use public, then by default it's in the search path so you can usually
leave off the 'public.'. Look at section 2.8 of the PostgreSQL User's
guide for more info (it's in the pgAdmin helpfile).

Regards, Dave.

pgadmin-support by date

Next:From: Dave PageDate: 2002-12-22 19:25:04
Subject: Re: Can't connect on Windows
Previous:From: Dave PageDate: 2002-12-22 19:15:57
Subject: Re: PGMigration and foriegn Keys

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group