Pavel Stehule <pavel.stehule@xxxxxxxxx> writes: > 2009/10/11 Andre Lopes <lopes80andre@xxxxxxxxx>: >> 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
