Annotating pg_dump/pg_restore - Mailing list pgsql-hackers

From Kevin Burke
Subject Annotating pg_dump/pg_restore
Date
Msg-id CAEYV4pbRbEaTyxTvhdtt1iq8ciPgyWY0AEsC4c1MBuWWajrr6w@mail.gmail.com
Whole thread Raw
Responses Re: Annotating pg_dump/pg_restore  (Guillaume Lelarge <guillaume@lelarge.info>)
List pgsql-hackers
Hi,
Normally I try to annotate incoming queries, to make it easier to diagnose slow ones. For example:

-- Users.findByPhoneNumber
SELECT * FROM ....

The pg_dump and pg_restore commands issue a COPY with no possibility of adding a comment. It would be useful to know who or what exactly is performing a COPY against a database - maybe a nightly backup script, maybe a developer copying a table. 

I was wondering if you could have a command line flag that let you attach a comment to the query?

Thanks!
Kevin 

--
kevin

pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: deparsing utility commands
Next
From: Alvaro Herrera
Date:
Subject: Re: deparsing utility commands