Re: Query to get name a data type of a view

On Friday, May 22, 2020, stan <stanb(at)panix(dot)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.