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

2009-10-11 Thread 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é.

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

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