Re: In pg_dump "no owner" mode don't dump owner names in

This fixes pg_dump so that when using the '-O' no owners option it does
not print the owner name in the object comment.

eg:

--
-- Name: actor; Type: TABLE; Schema: public; Owner: chriskl; Tablespace:
--

Becomes:

--
-- Name: actor; Type: TABLE; Schema: public; Owner: -; Tablespace:
--

This makes it far easier to do 'user independent' dumps. Especially for
distribution to third parties.

Chris

Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au> writes:
> 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?

regards, tom lane

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

Patch applied. Thanks.

---------------------------------------------------------------------------

Christopher Kings-Lynne wrote:
> This fixes pg_dump so that when using the '-O' no owners option it does
> not print the owner name in the object comment.
>
> eg:
>
> --
> -- Name: actor; Type: TABLE; Schema: public; Owner: chriskl; Tablespace:
> --
>
> Becomes:
>
> --
> -- Name: actor; Type: TABLE; Schema: public; Owner: -; Tablespace:
> --
>
> This makes it far easier to do 'user independent' dumps. Especially for
> distribution to third parties.
>
> Chris

> Index: src/bin/pg_dump/pg_backup_archiver.c
> ===================================================================
> RCS file: /projects/cvsroot/pgsql/src/bin/pg_dump/pg_backup_archiver.c,v
> retrieving revision 1.117
> diff -c -r1.117 pg_backup_archiver.c
> *** src/bin/pg_dump/pg_backup_archiver.c 15 Oct 2005 02:49:38 -0000 1.117
> --- src/bin/pg_dump/pg_backup_archiver.c 21 Nov 2005 07:19:39 -0000
> ***************
> *** 2404,2410 ****
> ahprintf(AH, "-- %sName: %s; Type: %s; Schema: %s; Owner: %s",
> pfx, te->tag, te->desc,
> te->namespace ? te->namespace : "-",
> ! te->owner);
> if (te->tablespace)
> ahprintf(AH, "; Tablespace: %s", te->tablespace);
> ahprintf(AH, "\n");
> --- 2404,2410 ----
> ahprintf(AH, "-- %sName: %s; Type: %s; Schema: %s; Owner: %s",
> pfx, te->tag, te->desc,
> te->namespace ? te->namespace : "-",
> ! ropt->noOwner ? "-" : te->owner);
> if (te->tablespace)
> ahprintf(AH, "; Tablespace: %s", te->tablespace);
> ahprintf(AH, "\n");

>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faq

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073