Here are some tests I did:
psql -h localhost -d mattermost -U mmuser
→ I can log in as mmuser!
mattermost=# SELECT schema_name FROM information_schema.schemata;
schema_namepg_toast
pg_catalog
information_schema
mattermost
(4 rows)
Database mattermost is ther and information_schema is there…but not public.
Now I deleted schema mattermost and created schema public…
…then I run again pgloader and get errror:
Database error 42P01: relation “mattermost.db_migrations” does not exist
QUERY: UPDATE mattermost.db_migrations set name=‘add_createat_to_teamembers’ where version=92;
But mySQL Shows:
mysql> SELECT * FROM mattermost.db_migrations WHERE version = 92;
±--------±----------------------------+
| Version | Name |
±--------±----------------------------+
| 92 | add_createat_to_teammembers |
±--------±----------------------------+
1 row in set (0.00 sec)
While PostgreSQL says.
SELECT * FROM information_schema.tables WHERE table_name = ‘mattermost.db_migrations’;
table_catalog | table_schema | table_name | table_type | self_referencing_column_name | reference_generation | user_defined_type_catalog | user_defined_type_schema | user_defined_type_name | is_insertable_into | is_typed | commit_action
---------------±-------------±-----------±-----------±-----------------------------±---------------------±--------------------------±-------------------------±-----------------------±-------------------±---------±--------------
(0 rows)