Updated the inspect.psql with the following items:
Missing foreign key field in the generated output: The issue of the foreign key field of a table not being present in the generated output has been resolved, ensuring complete information.
View considered as a table in the result: The problem of views being incorrectly listed as tables in the result has been resolved. Views are now properly distinguished and removed from the table list.
Duplication of foreign keys in the output: The duplication of foreign keys in the output has been resolved. The duplicates no longer appear in both the 'constraints' section and the 'foreign_keys' section.
Where statement missing in queries: The problem of missing WHERE statements in queries has been resolved by adding Tables-based queries, resulting in non-duplicate results in the output.
Support comments for tables and fields in the generated output
The incorrect column datatype in the generated JSON has been fixed.
The missing default values of the columns have been fixed.
Duplicate columns in the constraints have been removed.
Views with their definitions and column details have been added.
Updated the inspect.psql with the following items: