Re: pg_dump options and perhaps 'Enhancement request'

This guy raises a good point, albeit indirectly. The transitions from one major version to another need to be smoother if Postgres is going to gain any more acceptance in big database circles.

A dump file shouldn't have to be messed with to reload it into the next version. There should be a 'conversion tool' or script between each version. And if a customer waits 8 versions to update, those tools, used in sequence, should be able to change his old dump to be imported into the latest version.

Terry Yapt wrote:
> Ok.. ok...
>
> I know I can do a lot of things with external software or utilities (even with sed, vi or others). I can develop my own software tool to do what I want to do too. But, I think PostgreSQL team is porting this great DB to Win32 now. Ok, I can tell you the windows guys don't have so much utilities like linux/unix guys or worse perhaps they will be users only and don't know how to use perl or something similar.
>
> I only want a 'clear' pg_dump if it is possible and with SCHEMA.object_name ala ORACLE if it is possible too.
>
> Thanks a lot four your answers...
>
> Andrew Sullivan wrote:
>
>>On Thu, May 08, 2003 at 10:11:48PM +0200, Terry Yapt wrote:
>>
>>>1-) Are there any way to do a pg_dump without '--' COMMENTS ? For
>>>example, I don't like to have this in my output file:
>>>--
>>>-- TOC entry 19 (OID 26027)
>>>-- Name: TABLE news; Type: COMMENT; Schema: www; Owner: www
>>>--
>>
>>You could do this with grep (and something similar for blank lines):
>>
>>pg_dump [options] dbname | grep -v "^--" > dumpfile
>>
>>A
>>
>>--
>>----
>>Andrew Sullivan 204-4141 Yonge Street
>>Liberty RMS Toronto, Ontario Canada
>><andrew(at)libertyrms(dot)info> M2P 2A8
>> +1 416 646 3304 x110
>>
>>---------------------------(end of broadcast)---------------------------
>>TIP 3: if posting/reading through Usenet, please send an appropriate
>>subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
>>message can get through to the mailing list cleanly
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)
>