How to find a table having a specific column in postgresql

How to find a table having a specific column in postgresql

Asked on January 10, 2019 in PostgreSQL.
Add Comment


  • 1 Answer(s)

    you can query system catalogs:

    select c.relname
    from pg_class as c
    inner join pg_attribute as a on a.attrelid = c.oid
    where a.attname = and c.relkind = ‘r’

    Answered on February 4, 2019.
    Add Comment


  • Your Answer

    By posting your answer, you agree to the privacy policy and terms of service.