On Friday, May 22, 2020, stan <
stanb@panix.com> wrote:
When I run the following query,
SELECT column_name,data_type
FROM information_schema.columns
WHERE table_name = 'mfg_part_view';
I get the following result:
column_name | data_type
--------------+-------------------
mfg | USER-DEFINED
mfg_part_no | character varying
unit | USER-DEFINED
I need to return the name, and data type of each column for the specified
view.
Use the pg_catalog schema “tables” directly instead of the SQL standard information_schema view. The later doesn’t provide detail of PostgreSQL-specific features by definition.
David J.