Description
When planning a FortiAnalyzer report, it is sometimes necessary to know what table columns we are going to be using in our SQL statement.
Solution
In order to query all columns from a table in POSTGRESQL (internal DB engine) you can try the following query as an example right in the command line:
exec sql-query-generic "select column_name, data_type from INFORMATION_SCHEMA.COLUMNS where table_name = 'table_ref';"
