pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedinsert record in remote database
3+ messages / 2 participants
[nested] [flat]
* insert record in remote database
@ 2010-10-22 11:41 Maruti Nandan <tejas.tank.mca@gmail.com>
2010-10-23 22:07 ` Re: insert record in remote database Osvaldo Kussama <osvaldo.kussama@gmail.com>
0 siblings, 1 reply; 3+ messages in thread
From: Maruti Nandan @ 2010-10-22 11:41 UTC (permalink / raw)
To: pgsql-sql
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
--
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: insert record in remote database
2010-10-22 11:41 insert record in remote database Maruti Nandan <tejas.tank.mca@gmail.com>
@ 2010-10-23 22:07 ` Osvaldo Kussama <osvaldo.kussama@gmail.com>
2010-10-24 12:52 ` Re: insert record in remote database Osvaldo Kussama <osvaldo.kussama@gmail.com>
0 siblings, 1 reply; 3+ messages in thread
From: Osvaldo Kussama @ 2010-10-23 22:07 UTC (permalink / raw)
To: Maruti Nandan <tejas.tank.mca@gmail.com>; +Cc: pgsql-sql
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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: insert record in remote database
2010-10-22 11:41 insert record in remote database Maruti Nandan <tejas.tank.mca@gmail.com>
2010-10-23 22:07 ` Re: insert record in remote database Osvaldo Kussama <osvaldo.kussama@gmail.com>
@ 2010-10-24 12:52 ` Osvaldo Kussama <osvaldo.kussama@gmail.com>
0 siblings, 0 replies; 3+ messages in thread
From: Osvaldo Kussama @ 2010-10-24 12:52 UTC (permalink / raw)
To: tejas tank <tejas.tank.mca@gmail.com>; +Cc: pgsql-sql
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
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2010-10-24 12:52 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2010-10-22 11:41 insert record in remote database Maruti Nandan <tejas.tank.mca@gmail.com>
2010-10-23 22:07 ` Osvaldo Kussama <osvaldo.kussama@gmail.com>
2010-10-24 12:52 ` Osvaldo Kussama <osvaldo.kussama@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox