Hello,
My need is to list database tables and their fields in a table.
First step, I've created a sql that work fine.
SELECT table_name, column_name, data_type
FROM information_schema.columns
WHERE
table_name IN
(SELECT tablename
FROM pg_tables
WHERE schemaname = 'xxx'
AND tablename NOT IN ('xxx')
AND tablename NOT ILIKE ('i18n_%')
AND tablename NOT ILIKE ('stats_%'))
ORDER BY table_name ASC, column_name ASC;
Second step, I've created a new table to store the result with 2 more boolean colums
CREATE TABLE xxx.data_model AS (MY_FIRST_SELECT_ABOVE)
Third step, I've added 2 boolean fileds
In PGADMIN or other sgbd tools, displaying data is fine.
After syncing with phpmaker 2022, only the 2 added columns are shown !
Any ideas ?
Help welcome.
Regards