Received: from varsoon.denali.to ([216.151.155.108]) by postgresql.org (8.11.3/8.11.4) with ESMTP id g0904VB39453 for ; Tue, 8 Jan 2002 19:04:31 -0500 (EST) (envelope-from doug@wireboard.com) Received: (from doug@localhost) by varsoon.denali.to (8.11.6/8.9.3) id g0904WK13445; Tue, 8 Jan 2002 19:04:32 -0500 To: Bill Cunningham Cc: pgsql-general@postgresql.org Subject: Re: [SQL] Need help References: <3C31A2AF.B15798EE@wipro.com> <873d1g9300.fsf@npa01zz001.simplot.com> <3C3B5558.3000904@ballydev.com> From: Doug McNaught Date: 08 Jan 2002 19:04:32 -0500 In-Reply-To: Bill Cunningham's message of "Tue, 08 Jan 2002 12:23:52 -0800" Message-ID: Lines: 19 User-Agent: Gnus/5.0806 (Gnus v5.8.6) Emacs/20.5 MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Archive-Number: 200201/221 X-Sequence-Number: 19183 Bill Cunningham writes: > Actually this concept is used in production environments or classes > for seperating student's school work. > > I can see the need to create a Table1 under several different > names. Does postgresql have a schema concept like so: > dbuser1.Table1 > postgres.Table1 > > This is how DB2 does it. I understand that schemas are tentatively planned for 7.3, but they are not currently available. -Doug -- Let us cross over the river, and rest under the shade of the trees. --T. J. Jackson, 1863