2010/10/22 Maruti Nandan <tejas.tank....@gmail.com>: > have any one idea !!! > > postgres db, to insert record in a table of other database through > function!!! > > > u see the dblink , but it just use for select statement i want to > > > when trigger fire i want to insert record in other db > --
>From manual: dblink_exec executes a command (that is, any SQL statement that doesn't return rows) in a remote database. http://www.postgresql.org/docs/current/interactive/contrib-dblink-exec.html "sql: The SQL command that you wish to execute in the remote database, for example insert into foo values(0,'a','{"a0","b0","c0"}'). " Osvaldo -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
