From: | Darren Johnson <djohnson(at)greatbridge(dot)com> |
---|---|
To: | Allan Engelhardt <allane(at)cybaea(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: Comparing tables in different db's |
Date: | 2001-08-12 02:32:59 |
Message-ID: | 3B75EADB.7090507@greatbridge.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Allan Engelhardt wrote:
> (1) The output contains the OID and the owner, so I guess it won't work without stripping comments first?
>
I was using an older version of PostgreSQL which doesn't have
the comments, and it looks like I'll need to make the OID/owner
comments an option in pg_dump, once I get the further along
in the changes I am working on. In the mean time you can try
something like..
pg_dump -a -t table_name db1|egrep -v "\(OID|Owner" > db1_dump.out
but this is a hack to strip the offending comments, and
wouldn't work in every situation.
> (2) It (still) doesn't work if you have datetime columns with more than two digits in the miliseconds field (see below).
>
I'm not sure about this one, I need to do more investigation here. BTW what platform/OS
are you using?
Darren
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2001-08-12 02:47:14 | Re: Re: [PATCHES] Select parser at runtime |
Previous Message | Tom Lane | 2001-08-12 02:27:35 | Re: PL/pgSQL bug? |