system command in dblink?

From: AI Rumman <rummandba(at)gmail(dot)com>
To: pgsql-general General <pgsql-general(at)postgresql(dot)org>
Subject: system command in dblink?
Date: 2011-06-14 06:17:22
Message-ID: BANLkTimp9T-a+EgkLBGx-AfA1+HKdprF6w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Is it possible to execute system commands in dblink connections?

I need to execute \i /tmp/test.sh in a remote connection from my psql client
prompt.
I connected with the remote db using dblink_connect.

select dblink_connect('conn_1', 'dbname=newdb');

Any help please.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Vikram A 2011-06-14 06:29:53 Re: PGP encrypt/decrypt - Prereqistes
Previous Message Greg Smith 2011-06-14 05:33:14 Re: determine client os