Request a Demo
Home   >   mailing lists

Re: system command in dblink? - Mailing list pgsql-general

From Merlin Moncure
Subject Re: system command in dblink?
Date
Msg-id BANLkTi=sQbQx+SNVAb-2=H7i1CzzAVJt6Q@mail.gmail.com
Whole thread Raw
In response to system command in dblink?  (AI Rumman <rummandba@gmail.com>)
List pgsql-general
Tree view 
On Tue, Jun 14, 2011 at 1:17 AM, AI Rumman <rummandba@gmail.com> wrote:
> 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');

the '\i' syntax only means anything to psql, so no.  This might help
though: http://plsh.projects.postgresql.org/

merlin

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Executing \i of psql command using libpq library
Next
From: BangarRaju Vadapalli
Date:
Subject: random backend crashes - how to debug ( Is crash dump handler released ? )