On Friday, May 22, 2020, stan <st...@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.
