tanya ttg postgre di linux - Mailing list pgsql-admin

From ria ulfa
Subject tanya ttg postgre di linux
Date
Msg-id 9c3360200807010032v2f154417p47d2de7a3fa7b389@mail.gmail.com
Whole thread Raw
In response to tanya ttg postgre di linux  ("ria ulfa" <riakdr@gmail.com>)
List pgsql-admin
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/log.sql';
                ○    simps=nama dt base
                ○    log=nama tabel
                ○    log.sql=nama file tujuan
       tp muncul error:
       could not open file "/root/documents/log.sql" for writing: Permission denied
       sy ud ubah mode documents dg chmod -Rf 777 documents, sy jg ud ubah mode file log.sql agr root bs r,w,x. Tp errormsg nya te2p sama.
       namun, kalo pke cmd:   simps=# COPY log TO STDOUT;  isi tabel log bs lgsung muncul ke layar shell.
       kalo STDOUT dganti dg root file ko ga bisa??? padahal di man copy bgtu ptnjuknya
4.    cr yg bener gmn ya???
5.    sgt diharapkan bantuannya. Terimakasih banyak

pgsql-admin by date:

Previous
From: "ria ulfa"
Date:
Subject: tanya ttg postgre di linux
Next
From: "ria ulfa"
Date:
Subject: tanya ttg postgre di linux