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 lopes80an...@gmail.com:
 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

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

2009-10-11 Thread Tom Lane 
Pavel Stehule pavel.steh...@gmail.com writes:
 2009/10/11 Andre Lopes lopes80an...@gmail.com:
 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