Conversion MySql -> PostgresSQL

From: "William H(dot) Geiger III" <whgiii(at)openpgp(dot)net>
To: pgsql-general(at)hub(dot)org
Subject: Conversion MySql -> PostgresSQL
Date: 2000-10-29 00:20:14
Message-ID: 200010290135.VAA17116@domains.invweb.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

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).

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).

That's it for starters.

tks,

--
---------------------------------------------------------------
William H. Geiger III http://www.openpgp.net
Geiger Consulting

Data Security & Cryptology Consulting
Programming, Networking, Analysis

PGP for OS/2: http://www.openpgp.net/pgp.html
E-Secure: http://www.openpgp.net/esecure.html
---------------------------------------------------------------

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Martijn van Oosterhout 2000-10-29 03:37:31 Postgresql doesn't understand the unary plus
Previous Message Robert Vogt IV 2000-10-28 18:08:49 Re: newbie question: ERROR: getattproperties: no attribute tuple 1259 -2