On 1 Jul 2008, at 09:18, ria ulfa wrote:
i use linux fedora 7 and database PostgreSQL 8.
i want to copy table in postgre to a file.
i used code : simps=# COPY log TO '/root/documents/log.sql';
note= simps: name of database
but there is error: could not open file "/root/documents/log.sql
AIL PROTECTED]>
To: pgsql-admin@postgresql.org
Sent: Tuesday, 1 July, 2008 9:19:41 AM
Subject: [ADMIN] ask...!!!
i use linux fedora 7 and database PostgreSQL 8.
i want to copy table in postgre to a file.
i used code : simps=# COPY log TO '/root/documents/log.sql';
note= simps: name
Στις Tuesday 01 July 2008 11:12:39 ο/η ria ulfa έγραψε:
> i use linux fedora 7 and database PostgreSQL 8.
> i want to copy table in postgre to a file.
> i used code : simps=# COPY log TO '/root/documents/log.sql';
> note= simps: name of database
> but there is error: could not open file "/ro
On Tue, Jul 01, 2008 at 03:12:39PM +0700, ria ulfa wrote:
> i use linux fedora 7 and database PostgreSQL 8.
> i want to copy table in postgre to a file.
> i used code : simps=# COPY log TO '/root/documents/log.sql';
> note= simps: name of database
> but there is error: could not open file "/
Hello,
I don't think it's a good idea to store it under the /root directory,
since "normal" users like e.g. postgres don't have write permission
there (as the error message tells you).
You have to choose a directory where your database user definitely has
write permission.
bye-GERD-
ria ulf
i use linux fedora 7 and database PostgreSQL 8.
i want to copy table in postgre to a file.
i used code : simps=# COPY log TO '/root/documents/log.sql';
note= simps: name of database
but there is error: could not open file "/root/documents/log.sql" for
writing: Permission denied
what can i do
i use linux fedora 7 and database PostgreSQL 8.
i want to copy table in postgre to a file.
i used code : simps=# COPY log TO '/root/documents/log.sql';
note= simps: name of database
but there is error: could not open file "/root/documents/log.sql" for
writing: Permission denied
what can i do
i use linux fedora 7 and database PostgreSQL 8.
i want to copy table in postgre to a file.
i used code : simps=# COPY log TO '/root/documents/log.sql';
note= simps: name of database
but there is error: could not open file "/root/documents/log.sql" for
writing: Permission denied
what can i do
Dear master
Now I'm using PostgreSQL server but my company has plan to
change PostgreSQL to another database "hand made" by
software hous systems. Can you explain to me what kind of
factors to class list database engine. I mean how can I
compare for each database engine. Because I want to
exp
Hi:
Somebody knows a site in Mexico or USA that offer web hosting service, based on
postgresql ?
thanks in advanced?
Best regards, Joselo
ISC Jose Luis Orduña Centeno
Tecnologías de Información
CIATEQ A.C. Centro de Tecnología Avanza
10 matches
Mail list logo
