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

Re: working with schema

From: Christoph Haller <ch(at)rodos(dot)fzk(dot)de>
To: wei(dot)liang(at)eudoramail(dot)com
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: working with schema
Date: 2004-05-10 12:49:35
Message-ID: 200405101049.MAA13883@rodos (view raw or flat)
Thread:
Lists: pgsql-sql
> 
> 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 


In response to

pgsql-sql by date

Next:From: StefDate: 2004-05-10 13:08:08
Subject: Exceptions when 0 rows affected.
Previous:From: Theodore PetroskyDate: 2004-05-10 11:41:50
Subject: Re: not really SQL but I need info on BLOBs

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