Technical Note: How to query COLUMNS from a table in POSTGRESQL

[aorozco]

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';"