Dynamic DDL
- From: "Ketema" <ketema(at)gmail(dot)com>
- To: pgsql-general(at)postgresql(dot)org
- Subject: Dynamic DDL
- Date: 16 Apr 2007 13:37:43 -0700
- Message-id: <1176755863(dot)226764(dot)170230(at)d57g2000hsg(dot)googlegroups(dot)com>
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?
Home |
Main Index |
Thread Index