Re: [GENERAL] Using data for column names in plpgsql

2011-03-28 Thread Merlin Moncure
On Fri, Mar 25, 2011 at 6:18 PM, Jake Stride wrote: > Hi > > I'm attempting to do some partitioning in a database and am wondering > if I can use the data being inserted to insert into new schema. > > I have the following in the public schema: > > create table test (id serial, note varchar not nul

[GENERAL] Using data for column names in plpgsql

2011-03-25 Thread Jake Stride
Hi I'm attempting to do some partitioning in a database and am wondering if I can use the data being inserted to insert into new schema. I have the following in the public schema: create table test (id serial, note varchar not null, schema varchar not null) then create a schema: create schema