Re: dynamic 'INSERT' query? - Mailing list pgsql-sql

From Dinesh Pandey
Subject Re: dynamic 'INSERT' query?
Date
Msg-id 20050414150104.457BB53F8C@svr1.postgresql.org
Whole thread Raw
In response to Re: dynamic 'INSERT' query?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-sql
Yes here the TABLE NAME is also coming at runtime.

Like In Oracle I have done in this way:
-------------------------------------------
LOOPv_sql := 'INSERT INTO ' || mytable || ' VALUES(:in_sentryid_id,
:in_node_id)';    EXECUTE IMMEDIATE v_sql USING v_sentryid, v_nodeid;        
END LOOP;

How to convert this into Postgres?????

Thanks
Dinesh Pandey




pgsql-sql by date:

Previous
From: Richard Huxton
Date:
Subject: Re: Prepared query ?
Next
From: "Dinesh Pandey"
Date:
Subject: Re: Prepared query ?