Dynamic DDL

From: "Ketema" <ketema(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Dynamic DDL
Date: 2007-04-16 20:37:43
Message-ID: 1176755863.226764.170230@d57g2000hsg.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

create or replace function schema.insert_function(_schema text, _table
text) returns integer
as
$BODY$
declare
_affected integer;
begin
set search_path to _schema;
insert into _table (columns) values(vals);
return 0;
end;
$BODY$ language plpgsql;

is there any whay to get the functionality of above to work with out
have to build a string and use the execute function?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Martijn van Oosterhout 2007-04-16 20:47:13 Re: Dynamic DDL
Previous Message garry saddington 2007-04-16 20:33:45 delete with self join