Re: [GENERAL] Convert DECIMAL MySql field to PostGre. How?

2009-10-11 Thread Tom Lane 
Pavel Stehule  writes:
> 2009/10/11 Andre Lopes :
>> I have designed a database using MySql, but now I decided to move to
>> PostGre. I hava decimal fields with DECIMAL(10,6). How to convert this
>> fields to PostGre?

> use type NUMERIC(10,6)

DECIMAL works just fine too; it's an alias for NUMERIC.

regards, tom lane

-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Convert DECIMAL MySql field to PostGre. How?

2009-10-11 Thread Pavel Stehule 
Hello

use type NUMERIC(10,6)

Pavel Stehule

p.s. current name of this database is PostgreSQL, shortly Postgres :)

2009/10/11 Andre Lopes :
> Hi,
>
> I have designed a database using MySql, but now I decided to move to
> PostGre. I hava decimal fields with DECIMAL(10,6). How to convert this
> fields to PostGre?
>
> Best Regards,
> André.
>
>

-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general