Re: insert record in remote database

2010/10/22 Maruti Nandan <tejas(dot)tank(dot)mca(at)gmail(dot)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