I have installed the grocery crud version for codeigniter 4. I use the postgresql database and I have configured codeigniter 4 to connect to postgresql.
Apparently the connection works correctly, but when I try to access the data it seems that it is using the mysql syntax, for example I get this error:
pg_query (): Query failed: ERROR: syntax error at or near “FROM” LINE 1: SHOW COLUMNS FROM
It’s using the postgres driver (pg_query) but the model is not correct, ‘Show columns’ is not correct for postgres.
Some other grocery crud model file for postgres is needed?
Thank you in advance.