On Thu, Nov 16, 2006 at 06:23:23PM -0700, Jim Nasby wrote:
> Well, for tables it wouldn't be hard to craft a query that spits out
> the appropriate ALTER TABLE RENAME statements. Unfortunately, ALTER
> TABLE doesn't support renaming columns, but it might be safe to run
> an update on the syst
On Nov 15, 2006, at 12:41 PM, Dan Armbrust wrote:
I'm trying to convert a database from either MS Access or MySQL
into Postgres. I have found a couple of tools that will almost do
what I want - but not quite. To make things match up with code
that is already written - I need to have all o
If you don't mind an intermediate step you could use Pg2xbase
http://www.klaban.torun.pl/prog/pg2xbase/
This program takes dbf files and inputs them into Postgres. It has an option
for lower casing field names. You can specify the table name when you do the
conversion.
On Wednesday 15 November 20
<[EMAIL PROTECTED]>
To: "Bob Pawley" <[EMAIL PROTECTED]>
Cc: "Postgresql"
Sent: Tuesday, January 31, 2006 5:41 PM
Subject: Re: [GENERAL] Data Conversion
On Feb 1, 2006, at 10:32 , Bob Pawley wrote:
I'm a little concerned about stability since my Postgresql a
On Feb 1, 2006, at 10:32 , Bob Pawley wrote:
I'm a little concerned about stability since my Postgresql
application has failed three times in the last couple of months. It
seems to have failed when too many things are happening at the same
time - mostly things that have been instigated by
ginal Message -
From: "Michael Glaesemann" <[EMAIL PROTECTED]>
To: "Bob Pawley" <[EMAIL PROTECTED]>
Cc: "Postgresql"
Sent: Tuesday, January 31, 2006 5:18 PM
Subject: Re: [GENERAL] Data Conversion
On Feb 1, 2006, at 9:53 , Bob Pawley wrote:
Two way
On Feb 1, 2006, at 9:53 , Bob Pawley wrote:
Two way conversion will be a neccesity. My thought was that dual
conversion could be not only complex but also have problems with
stability.
I'm not sure why it would be a stability issue. As for the
complexity, I think once it's implemented yo
I would create functions. Store the data in one format, and convert
with functions as needed on the fly.
E.g.:
SELECT Fahrenheit_to_Celcius(Fahrenheit_temp) FROM temperatures;
If that seems kludgy for the users, then create views for them that
perform the needed conversions using the functions.
Tuesday, January 31, 2006 4:20 PM
Subject: Re: [GENERAL] Data Conversion
On Feb 1, 2006, at 9:02 , Bob Pawley wrote:
1 – creating a single table of data in the format of the
users’ choice, then converting the data en masse as the user requests.
Sort of like conversion-on-de
On Feb 1, 2006, at 9:02 , Bob Pawley wrote:
1 – creating a single table of data in the format of
the users’ choice, then converting the data en masse as the user
requests. Sort of like conversion-on-demand.
I've been thinking about a similar application recently, and leaning
Bill <[EMAIL PROTECTED]> writes:
> I have some data in dBase III compatible files (created with Alpha
> Four, v4) that I want to move to Postgresql. I have already read the
> Admin pages of the manual and didn't see anything that would point
> the way.
>
> Does anyone else have any suggestio
11 matches
Mail list logo
