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

rfc: add pg_dump options to dump output

From: Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>
To: pgsql-hackers(at)postgresql(dot)org
Subject: rfc: add pg_dump options to dump output
Date: 2008-06-02 20:54:22
Message-ID: 200806021654.22126.xzilla@users.sourceforge.net (view raw or flat)
Thread:
Lists: pgsql-hackers
I would like to add the flags given to pg_dump into the output of the pg_dump 
file. For text dumps, the output would go on a line below the current header, 
so output would look like:

--
-- PostgreSQL database dump complete
--
-- Generated by: pg_dump -s -U rob pagila 
--

For compressed dumps, the output could go into the headers created with -l, 
for example:

; Archive created at Mon Jun  2 16:43:19 2008
;     dbname: pgods
;     TOC Entries: 3
;     Compression: -1
;     Dump Version: 1.10-0
;     Format: CUSTOM
;     Integer: 4 bytes
;     Offset: 8 bytes
;     Dumped from database version: 8.3.1
;     Dumped by pg_dump version: 8.3.1
;     Generated by: pg_dump -s -U rob -Fc pagila
;
;
; Selected TOC Entries:


Anyone see any issues with this? Should there be other information taken into 
account? Does this need to be an option itself, or can we just do it in all 
cases? 

-- 
Robert Treat
Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL

Responses

pgsql-hackers by date

Next:From: Josh BerkusDate: 2008-06-02 21:06:57
Subject: Re: rfc: add pg_dump options to dump output
Previous:From: Andreas 'ads' ScherbaumDate: 2008-06-02 20:40:47
Subject: Re: Core team statement on replication in PostgreSQL

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