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
ownsoftware tool to do what I want to do too. But, I think PostgreSQL team is porting this great DB to Win32 now. Ok,
Ican tell you the windows guys don't have so much utilities like linux/unix guys or worse perhaps they will be users
onlyand 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@libertyrms.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@postgresql.org so that your
> message can get through to the mailing list cleanly