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

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

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

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group