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

Re: [SQL] How do I copy part of table from db1 to db2

From: Joost Kraaijeveld <J(dot)Kraaijeveld(at)Askesis(dot)nl>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Roman Neuhauser <neuhauser(at)sigpipe(dot)cz>,"Pgsql-sql(at)postgresql(dot)org" <Pgsql-sql(at)postgresql(dot)org>,Pgsql-General <pgsql-general(at)postgresql(dot)org>
Subject: Re: [SQL] How do I copy part of table from db1 to db2
Date: 2005-08-31 15:14:08
Message-ID: 1125501248.9456.74.camel@Panoramix (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-sql
On Wed, 2005-08-31 at 10:29 -0400, Tom Lane wrote:
> Joost Kraaijeveld <J(dot)Kraaijeveld(at)Askesis(dot)nl> writes:
> If, as seems more likely, there's a mishmash of different encodings then
> you are in for some pain.  At the minimum you'll have to separate out
Yep. The original database (which is copied to an SQL-ASCII PostgreSQL
database) is a mishmash of encodings. Actually no official encoding is
given for the database. 

But I managed to get an acceptable (for me that is) import, only losing
all the diacritical chars for this moment (see other mail)

Thanks for responding,

Joost. 

In response to

pgsql-sql by date

Next:From: Tom LaneDate: 2005-08-31 15:22:21
Subject: Re: insert only if conditions are met?
Previous:From: Henry OrtegaDate: 2005-08-31 15:09:54
Subject: insert only if conditions are met?

pgsql-general by date

Next:From: Scott MarloweDate: 2005-08-31 15:35:12
Subject: Re: detection of VACUUM in progress
Previous:From: Joost KraaijeveldDate: 2005-08-31 15:02:17
Subject: Re: [SQL] How do I copy part of table from db1 to db2

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