How to get the datatype of all columns of a PostgreSQL table

Question

What command/query should I use to see the list of columns and their datatypes of a table in PostgreSQL?

Answer 1

Go to the psql commande line and type the following command:

\d+ table_name

If you want to use SQL, type the following query:

select column_name,data_type
from information_schema.columns
where table_name = 'YOUR_TABLE_NAME';