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

Re: Dynamic DDL


  • From: Martijn van Oosterhout <kleptog(at)svana(dot)org>
  • To: Ketema <ketema(at)gmail(dot)com>
  • Cc: pgsql-general(at)postgresql(dot)org
  • Subject: Re: Dynamic DDL
  • Date: Mon, 16 Apr 2007 22:47:13 +0200
  • Message-id: <20070416204713(dot)GC3324(at)svana(dot)org>

On Mon, Apr 16, 2007 at 01:37:43PM -0700, Ketema wrote:
> create or replace function schema.insert_function(_schema text, _table
> text) returns integer

<snip>

> 	set search_path to _schema;
> 	insert into _table (columns) values(vals);

<snip>

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

No.

Have a nice day,
-- 
Martijn van Oosterhout   <kleptog(at)svana(dot)org>   http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.

Attachment: signature.asc
Description: Digital signature



Home | Main Index | Thread Index

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