https://sqlines.com/ 2026-04-09T12:50:14+00:00 https://sqlines.com/ https://sqlines.com/lib/images/favicon.ico text/html 2025-01-08T07:44:33+00:00 https://sqlines.com/mysql-to-postgresql/bit?rev=1736322273&do=diff In MySQL and PostgreSQL, the BIT data type stores bit values. MySQL allows you to store up to 64 bits, while PostgreSQL does not have maximum length restrictions. MySQL and PostgreSQL: -- Sample table CREATE TABLE bits ( c1 BIT, c2 BIT(3) ); -- Sample data INSERT INTO bits VALUES (b'0', b'101'); text/html 2022-02-16T16:28:35+00:00 https://sqlines.com/mysql-to-postgresql/constraint_relation_already_exists?rev=1645028915&do=diff When migrating tables from MySQL to PostgreSQL you can notice “ERROR: relation “constraint_name” already exists” error. For example, MySQL: CREATE TABLE u1 (c1 INT, CONSTRAINT un UNIQUE(c1)); # Query OK, 0 rows affected (0.10 sec) CREATE TABLE u2 (c1 INT, CONSTRAINT un UNIQUE(c1)); # Query OK, 0 rows affected (0.04 sec)