Re: How can I do this?

> 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