Re: insert record in remote database

2010/10/24 tejas tank <tejas.tank.mca@gmail.com>:
> Hello,
>     Thanks a lot,
>      This doc i have been read , i was thought it work but when i fire this
> with my plsql on that time error message come that function is not define.
>
>    how to configure the postgres database so this module will enable
>   is their any database driver have to setup or any configuration i have to
> made.
>   i am use postgresql database with ubuntu operating system. yes as you
> suggested solution will work but send me details how will i  configure...
>


Follow the instructions at:
http://www.postgresql.org/docs/current/interactive/contrib.html

For Ubuntu: with Synaptic Package Manager install postgresql-contrib.


>    My Dear, Thanks a lot for you response
>
>
>
> On Sun, Oct 24, 2010 at 3:37 AM, Osvaldo Kussama <osvaldo.kussama@gmail.com>
> wrote:
>>
>> 2010/10/22 Maruti Nandan <tejas.tank.mca@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