Re: psql o and g options not working

From: Andreas Wenk <a(dot)wenk(at)netzmeister-st-pauli(dot)de>
To: robin isard <robin(dot)isard(at)gmail(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: psql o and g options not working
Date: 2009-08-09 20:35:03
Message-ID: 4A7F32F7.6000300@netzmeister-st-pauli.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

robin isard wrote:
> Hi,
>
> Whenever I try to use the \o or \g options to output a sql query to a
> file, I always get a "File or directory does not exist error." The
> file does exist and I've given it every permission possible, ensured
> it's owned by the postgres user, and made sure it's in a directory
> postgres can write to.
>
> What am I doing wrong? I'm using postgresql 8.3.

Can you provide the command you use in psql and the following error
message, the postgresql version you use and the operating system?

By the way. On a ubuntu box this is working for me:

test=# \g /tmp/bla.sql

tmp$ ll
-rw-r--r-- 1 postgres postgres 598 2009-08-09 22:32 bla.sql

Cheers

Andy

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Peter Jackson 2009-08-10 09:56:08 Help sub query
Previous Message robin isard 2009-08-09 19:52:29 psql o and g options not working