- Determine Number of Columns in a PostGreSQL Table
select count(*) from information_schema.columns
where table_name='<table_name>’;
2. Determine all tables with their column count
select distinct (table_name),count(*) from information_schema.columns
select count(*) from information_schema.columns
where table_name='<table_name>’;
2. Determine all tables with their column count
select distinct (table_name),count(*) from information_schema.columns