Hi,
I can get postgres to log unsuccessful queries, including the user who
wrote them, but I'm missing how to get postgres to log the successful
queries too (I don't need a store of the answer, just the query
itself). How do I do this?
Thanks,
Matthew
--
Matthew Vernon
Quantitative Veterinary
t...@sss.pgh.pa.us (Tom Lane) writes:
Matthew Vernon matthew.ver...@sac.ac.uk writes:
naiively, you might try:
\set pwd '\'' `pwd` '\''
COPY table FROM :pwd || '/relative/path/to/data' ;
Umm ... why don't you just use a relative path as-is, with \copy
instead of COPY?
Thanks
|| '/relative/path/to/data' ;
but that doesn't work because the concatenation operator can't be used
there. How should I be doing this?
Thanks,
Matthew
--
Matthew Vernon
Quantitative Veterinary Epidemiologist
Epidemiology Research Unit, SAC Inverness
--
Sent via pgsql-general mailing list
Matthew Vernon matthew.ver...@sac.ac.uk writes:
naiively, you might try:
\set pwd '\'' `pwd` '\''
COPY table FROM :pwd || '/relative/path/to/data' ;
I should also note that I want to run a series of these commands, hence
setting pwd once and then wanting to use it multiple times.
Matthew
Matthew Vernon matthew.ver...@sac.ac.uk writes:
naiively, you might try:
\set pwd '\'' `pwd` '\''
COPY table FROM :pwd || '/relative/path/to/data' ;
so I could do:
\set path '\'' `pwd` '/path/to/data1' '\''
COPY table1 FROM :path;
\set path '\'' `pwd` '/path/to/data2' '\''
COPY table2 FROM
log shipping), or will I have to use
slony?
Thanks,
Matthew
--
Matthew Vernon
Quantitative Veterinary Epidemiologist
Epidemiology Research Unit, SAC Inverness
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org