On Thu, 2006-07-27 at 13:02 +0200, Karsten Hilbert wrote:
Any chance you could do a text dump with --no-owner --no-acl ?
The pgdump is already --no-owner, but I forgot --no-acl. I just uploaded a new tarball using both flags.
BTW, you can generate this yourself with what you have usin
On Wed, Jul 26, 2006 at 08:48:14AM -0700, Reece Hart wrote:
> In case your interested in these "pgtools" views, I've uploaded them to
> http://harts.net/reece/pgtools/ .
I am looking into it.
Any chance you could do a text dump with --no-owner --no-acl ?
Thanks,
Karsten
--
GPG key ID E4071346
On Wed, 2006-07-26 at 15:18 +0200, Karsten Hilbert wrote:
> > For some kinds of changes, and especially those that make
> destructive
> > in-place changes that might require debugging, I've written views
> which
> > generate the SQL statements to execute.
> Would you mind giving a small example ? T
On Tue, 2006-07-25 at 17:21 -0500, MC Moisei wrote:
The main thing is I changed a bunch of date types to timestamp type. Is
there a simple way to change the type on such fields ?
Yes, and more generally to change the type of a column. See below:
[EMAIL PROTECTED]> create table t
lt;[EMAIL PROTECTED]>
CC: pgsql-general
Subject: Re: [GENERAL] Mapping/DB Migration tool
Date: Tue, 25 Jul 2006 14:49:34 -0700
On Tue, 2006-07-25 at 13:59 -0500, MC Moisei wrote:
> I'm looking to migrate psql db1 to a psql db2 that has a different
> structure
> even th
On Tue, 2006-07-25 at 13:59 -0500, MC Moisei wrote:
I'm looking to migrate psql db1 to a psql db2 that has a different structure
even though 70% would be the same.
Depending on how much the structure changes (as opposed to more trivial things like column names), you might consider
On Jul 25, 2006, at 2:59 PM, MC Moisei wrote:
I'm looking to migrate psql db1 to a psql db2 that has a different
structure even though 70% would be the same. I'd need a tool that
allows me to map field to field and then migrate the data from one
db to another. Needless to say that preservi
Hello, MC.
Only human can do this. Moreover, if "data integrity is very
important".
Regards
You wrote:
MM> Hi,
MM> I'm looking to migrate psql db1 to a psql db2 that has a different structure
MM> even though 70% would be the same. I'd need a tool that allows me to map
MM> field to field and th
Hi,
I'm looking to migrate psql db1 to a psql db2 that has a different structure
even though 70% would be the same. I'd need a tool that allows me to map
field to field and then migrate the data from one db to another. Needless to
say that preserving data integrity is very important.
Any goo
