Trying to connect to pgsqlite from pgAdmin4, I get the message
Unable to connect to server:
Query execution failed: Protocol error: Unrecognized SET command: SET DateStyle=ISO
Additional info in pgsqlite's log:
EXECUTOR: execute_query called with: 'SET DateStyle=ISO; SET client_min_messages=notice; SELECT set_config('bytea_output','hex',false) FROM pg_show_all_settings() WHERE name = 'bytea_output'; SET client_encoding='utf-8';'
It looks like pgsqlite expects spaces around the equal sign. This doesn't seem mandatory in PostgreSQL syntax.
Trying to connect to pgsqlite from pgAdmin4, I get the message
Additional info in pgsqlite's log:
It looks like pgsqlite expects spaces around the equal sign. This doesn't seem mandatory in PostgreSQL syntax.