[GENERAL] Logging successful SELECTS?

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

Re: [GENERAL] COPY FROM in psql

t...@sss.pgh.pa.us (Tom Lane) writes: > Matthew Vernon 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 pat

Re: [GENERAL] COPY FROM in psql

Matthew Vernon 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

Re: [GENERAL] COPY FROM in psql

Matthew Vernon 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 us

[GENERAL] COPY FROM in psql

;\'' COPY table FROM :pwd || '/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,

[GENERAL] Replication with infrequent large updates

ation (via 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.post