X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 0367CD1E153 for ; Wed, 12 May 2004 07:20:18 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 02224-10 for ; Wed, 12 May 2004 07:19:59 -0300 (ADT) Received: from whowhere.com (in02-fes1.whowhere.com [209.202.220.218]) by svr1.postgresql.org (Postfix) with SMTP id C866FD1E136 for ; Wed, 12 May 2004 07:19:54 -0300 (ADT) Received: from Unknown/Local ([?.?.?.?]) by whowhere.com; Wed, 12 May 2004 10:19:45 -0000 To: pgsql-sql@postgresql.org Date: Wed, 12 May 2004 03:19:45 -0700 From: "William Anthony Lim" Message-ID: Mime-Version: 1.0 X-Sent-Mail: off Reply-To: wei.liang@eudoramail.com X-Mailer: MailCity Service X-Priority: 3 Subject: Re: working with schema X-Sender-Ip: 202.155.52.198 Organization: Lycos Mail (http://www.mail.eudoramail.com) Content-Type: text/plain; charset=us-ascii Content-Language: en Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200405/103 X-Sequence-Number: 17817 Christoph, First, is it safe for multi user? I mean maybe first user need working with D200402, second one need with D200403, if I do this in first user connection: SET search_path to D200402 ; does it affect to the second user search path? Second, I want it dinamic. So, if I want to using D200402, I just need to pass 'D200402' string in the argument of the function. Got my point? Thanks anyway, William >> >> Hi all, >> >> I'm just experimenting with schema usage. I'm going to use it as a fake 'multi-database' system. Is Postgresql support coding schema name using string variable so I can pass it with parameter? I'm give u an example: >> >> I have schema: D200401,D200402.D200403,D200404, etc. >> >> I've set my user just like the schema name, so who login with D200401 will be using D200401 schema. When someone using D200401 schema, they sometime want to access another schema, so in my thought I can use variable like this: >> >> sPointer='D200403' >> >> select * from sPointer.myTable -- Question: How to write it to work properly? >> >> Thanks >> >> >> William >> >> >SET search_path to D200401 ; >SET search_path to D200402 ; >... >should do the job. > >Regards, Christoph > > >---------------------------(end of broadcast)--------------------------- >TIP 4: Don't 'kill -9' the postmaster > Need a new email address that people can remember Check out the new EudoraMail at http://www.eudoramail.com