Re: Conversion MySql -> PostgresSQL

On Sat, 28 Oct 2000, William H. Geiger III wrote:

> Hi,
>
> I am new to PostgreSQL and I am trying to convert a MySQL database over.
> There are a couple of basics I need to clear up:
>
> On the numeric INT types can they be set to unsigned? I have 32-bit &
> 64bit unsigned integers that I need to store in the majority of the tables
> in the database. All the numeric data in the tables are unsigned ints.
No, int4 is signed 32 bits, int8 is signed 64 bits...if you need unsigned
64 bit, I think you may be out of luck...

> What are the table size limits? Are there any limits outside the
> filesystem limits that the tables reside on (mysql has a 4Gb/table limit).
No, it'll create multiple files on host filesystem if necessary.

> I am not quite sure on how to handle BLOB data. I have 2 tables that have
> BLOB fields. I don't need the server to do anything with the data other
> that to store the data and retrieve it based on queries on other fields
> (no direct queries on the BLOB fields).
postgres supports blobs too...

-alex