Answers for "how to get table column names in postgresql"

postgres get columns names

SELECT *
  FROM information_schema.columns
 WHERE table_name   = 'your_table'
     ;

Posted by: Guest on March-12-2021

postgresql get table names

SELECT table_name
  FROM information_schema.tables
 WHERE table_schema='public'
   AND table_type='BASE TABLE';

Posted by: Guest on May-26-2020

Code answers related to "how to get table column names in postgresql"