Skip site navigation (1) Skip section navigation (2)

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

From: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
To: Patches <pgsql-patches(at)postgresql(dot)org>
Subject: In pg_dump "no owner" mode don't dump owner names in comments
Date: 2005-11-21 07:32:35
Message-ID: 43817813.6090408@familyhealth.com.au (view raw or flat)
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.

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

Attachment: noowner.txt
Description: text/plain (994 bytes)

Responses

pgsql-patches by date

Next:From: Alvaro HerreraDate: 2005-11-21 13:33:08
Subject: Re: DROP OWNED again
Previous:From: Andrew DunstanDate: 2005-11-20 20:30:15
Subject: Re: Numeric 508 datatype

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group