Re: How can I do this? - Mailing list pgsql-general

From Chris Boget
Subject Re: How can I do this?
Date
Msg-id 001d01c2b7e9$4c68e140$8c01a8c0@ENTROPY
Whole thread Raw
In response to How can I do this?  ("Boget, Chris" <chris@wild.net>)
List pgsql-general
> So if you have
> card_id | card_name
> --------+--------------
>     277 | 123456789abc
>     727 | 123456789bbc
>     772 | 123456789bca
> which card_id do you want to select for trader_haves_old.card_name =
> '123456789bbc'?

That's a perfectly valid point.  And as I said, I'd be able to get the proper
record number for 99+%.  Happily, there aren't situations like the one you
describe.  The names of the cards are almost all distinguishable within the
first 9 characters. That's why I chose it as my aribitrary value. :p

> >Sadly, the MySQL database wasn't normalized and I've been running into a
> >lot of roadblocks (mainly from the fact that I'm still learning PG) in converting
> >it over.
> While you are still unfamiliar with the new DB, don't make several steps at once.
> Strictly separate the tasks of
> a) importing data,

Already done in temporary holding tables.

> b) cleaning up structures (normalization),

Done.  These are the tables I'm trying to move the data to.

> c) cleaning up data.

Haven't done this.  Perhaps it would be a good idea to update the temp table with
the proper values before moving over the the actual table.  This would certainly
make things a heck of a lot easier!

> Good luck!

Thank you very much for your help and your advice!

Chris


pgsql-general by date:

Previous
From: Manfred Koizar
Date:
Subject: Re: How can I do this?
Next
From: "Brian Johnson"
Date:
Subject: Help - moving data to new table structure