| From: | Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | Patches <pgsql-patches(at)postgresql(dot)org> |
| Subject: | Re: In pg_dump "no owner" mode don't dump owner names in |
| Date: | 2005-11-22 01:51:21 |
| Message-ID: | 43827999.7040009@familyhealth.com.au |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-patches |
>>This fixes pg_dump so that when using the '-O' no owners option it does
>>not print the owner name in the object comment.
>
> Why is that a good idea?
At the moment I want to dump sample databases for a project. I don't
want my name or username appearing anywhere in them. I dump without
owners or privileges since they're irrelevant and will refer to users
that just don't exist.
So, at the moment I need to run the dumps through sed to remove the
reference to the owner usernames in the dumps, otherwise everyone can
see half the users in our database...
Chris
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Zeugswetter Andreas DCP SD | 2005-11-22 09:07:15 | Re: [HACKERS] Should libedit be preferred to libreadline? |
| Previous Message | Tom Lane | 2005-11-22 01:09:16 | Re: [HACKERS] Should libedit be preferred to libreadline? |