X-Original-To: pgsql-sql@postgresql.org Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 24C02475C8B for ; Mon, 3 Mar 2003 20:28:29 -0500 (EST) Received: from postgresql.org ([64.49.215.8]) by localhost (postgresql.org [64.49.215.8:10024]) (amavisd-new) with SMTP id 61125-10 for ; Mon, 3 Mar 2003 20:28:27 -0500 (EST) Received: from SLEXC1.server.power.bellhow.com (slc-fw1.pqbs.com [63.121.54.230]) by postgresql.org (Postfix) with ESMTP id BA783475B84 for ; Mon, 3 Mar 2003 20:28:27 -0500 (EST) Received: by slexc1.server.power.bellhow.com with Internet Mail Service (5.5.2653.19) id ; Mon, 3 Mar 2003 18:28:31 -0700 Message-ID: From: "Hepworth, Mike" To: "'pgsql-sql@postgresql.org'" Subject: SCHEMA's Date: Mon, 3 Mar 2003 18:30:40 -0700 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2653.19) Content-Type: text/plain; charset="iso-8859-1" X-Virus-Scanned: by amavisd-new X-Archive-Number: 200303/105 X-Sequence-Number: 12145 Need some help with schema's. I want to be able make a user have a default schema other than public. I want to be able to have several schema's with the same group of tables define in each one. (Example) schema a (users 1,2,3) table a table b table c schema b (users 4,5,6) table a table b table c schema c (users 7,8,9) table a table b table c When a user logs into the database they will go to there default schema and not the public schema. (Example) User 5 logs in and by default uses a, b, c tables under schema b. Any ideas? Thanks, Mike Hepworth.....