i want to copy table from file with command:
COPY log FROM '/tmp/logfile.txt';
but there is error:
ERROR: could not open file "/tmp/logfile.txt" for reading: Permission
denied
what can i do for repair this error??
thanks for the answer..
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
mw tanya: (sy pake fedora 7, dtbase postgreSQL)
1.kalo mw copy isi tabel dlm dtbase ke flat file hrs masuk ke dtbasenya
sbg user postgres kan?
2.Command yg dpake apa?
3.Sy ud nyoba:
●masuk k postgre dg user postgres
●command: simps=# COPY log TO '/root/documents/lo
mw tanya: (sy pake fedora 7, dtbase postgreSQL)
1.kalo mw copy isi tabel dlm dtbase ke flat file hrs masuk ke dtbasenya
sbg user postgres kan?
2.Command yg dpake apa?
3.Sy ud nyoba:
●masuk k postgre dg user postgres
●command: simps=# COPY log TO '/root/documents/lo
mw tanya: (sy pake fedora 7, dtbase postgreSQL)
1.kalo mw copy isi tabel dlm dtbase ke flat file hrs masuk ke dtbasenya
sbg user postgres kan?
2.Command yg dpake apa?
3.Sy ud nyoba:
●masuk k postgre dg user postgres
●command: simps=# COPY log TO '/root/documents/lo
