Getting attribute of type postgres

Question

lets say I create a type like this:

CREATE TYPE books AS (
  book_id NUMERIC
, row_num NUMERIC
);

I want to write a query that returns me the attributes (book_id, row_num) of books.

I am not sure how to do this?

Kaushik Nayak · Accepted Answer · 2019-05-30 05:47:51Z

1

Use this

SELECT array_agg(a.attname) 
  FROM   pg_class c JOIN pg_attribute a 
         ON c.oid = a.attrelid
WHERE  c.relname = 'books';

Result

     array_agg
-------------------
 {book_id,row_num}
(1 row)

answered May 30, 2019 at 5:41

Kaushik Nayak

32k6 gold badges36 silver badges54 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

@dgamma3 : You're welcome. Please check. I've simplified the query.