MySQL vs. PostgreSQL

BGPUG Conf 2017 25.06.2017

1. BGPUG Conf 2017

2. MySQL:
mysql> CREATE TABLE test (id integer, name varchar(20));
Query OK, 0 rows affected (0.00 sec)
mysql> INSERT INTO test(id, name) VALUES(1, 'ime koeto e mnooogooo dylgo');
Query OK, 1 row affected, 1 warning (0.00 sec)
mysql> SELECT * FROM test;
+------+----------------------+
| id | name |
+------+----------------------+
| 1 | ime koeto e mnooogoo |
+------+----------------------+
PostgreSQL:
postgres=# CREATE TABLE test(id integer, name varchar(20));
CREATE TABLE
postgres=# INSERT INTO test(id, name) VALUES(1, 'ime koeto e mnooogooo
dylgo');
ERROR: value too long for type character varying(20)