Annotating pg_dump/pg_restore

From: Kevin Burke <burke(at)shyp(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Annotating pg_dump/pg_restore
Date: 2015-08-20 16:43:09
Message-ID: CAEYV4pbRbEaTyxTvhdtt1iq8ciPgyWY0AEsC4c1MBuWWajrr6w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Alvaro Herrera 2015-08-20 16:46:14 Re: deparsing utility commands
Previous Message Alvaro Herrera 2015-08-20 16:35:58 Re: deparsing utility commands