On Tue, Jun 14, 2011 at 1:17 AM, AI Rumman <rummandba(at)gmail(dot)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