How To Describe Tables In PostgreSQL Using SQL Shell psql And pgAdmin ||...

Only 3.9% of viewers are subscribing to my channel 😓.

I request you to please give click on Subscribe button.

It really helps me grow 😢.

SELECT COLUMN_NAME  

FROM information_schema.COLUMNS  

WHERE TABLE_NAME = 'table_name';  

SELECT COLUMN_NAME

FROM information_schema.COLUMNS  

WHERE TABLE_NAME = 'actor'; 

SELECT *

FROM information_schema.COLUMNS  

WHERE TABLE_NAME = 'actor';