There is something still annoying me Scott..
eg: I want to have function that take a string argument that indicates which schema i
want to use.
create function testf(varchar)
returns ...
..
..
..
..
My question is how to use the argument in the function, maybe looks like:
select * from $1.test
On Wed, 12 May 2004, William Anthony Lim wrote:
> 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 s
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 D2
>
> 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.
>
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
