On Jan 21, 2005, at 11:44 AM, sarlav kumar wrote:
> The problem is that I dont have permission to create directories as a
> postgres user.
> If I can get the \copy command or the \! pg_dump command to work, that
> would be great.
The commands starting with \ are psql commands. They are only executed
on the client side by psql. Stored procedures of course run on the
server, and don't know anything about psql \commands. What you can do
is setup a script for psql that first calls your stored procedure and
then uses \copy or \!pg_dump. But you can't put these commands in the
John DeSoi, Ph.D.
Power Tools for PostgreSQL
In response to
pgsql-novice by date
|Next:||From: Klaus||Date: 2005-01-21 22:33:40|
|Subject: How to update dependent tables AND design considerations|
|Previous:||From: operationsengineer1||Date: 2005-01-21 21:40:33|
|Subject: SQL and DB Connection Question (Interfacing with PHP)|