How to get a list column names and datatypes of a table in PostgreSQL?

How to get a list column names and datatypes of a table in PostgreSQL?

sql postgresql sqldatatypes

postgresql

Difference between DECIMAL and NUMERIC datatype in PSQL

postgresql rdbms sqldatatypes

postgresql

Difference between JSON and JSONB in Postgres [duplicate]

json postgresql sqldatatypes jsonb

postgresql

What is an appropriate data type to store a timezone?

postgresql datetime timezone sqldatatypes

postgresql

Can we create a column of character varying(MAX) with PostgreSQL database

postgresql postgresql-9.3 sqldatatypes

postgresql

Performance difference between UUID, CHAR, and VARCHAR in PostgreSql table?

sql postgresql database-performance sqldatatypes

postgresql

Differences between ROWTYPE, TYPE, and RECORD in postgresql?

postgresql plpgsql rdbms sqldatatypes

postgresql

Benchmark: bigint vs int on PostgreSQL

performance postgresql int sqldatatypes bigint

postgresql

postgres change data type of view column from unknown to text

postgresql view sqldatatypes

postgresql

Difference between Bit and Boolean datatypes in PostgreSQL

postgresql sqldatatypes

postgresql

Best PostgreSQL datatype for storing key-value maps?

json postgresql sqldatatypes jsonb hstore

postgresql

Column type for ZipCode in PostgreSQL database?

postgresql zipcode sqldatatypes

postgresql

Handling Postgres json datatype in slick, scala

postgresql scala slick sqldatatypes

postgresql

Should I use Postgres' bigserial for records in a new application?

java sql postgresql sqldatatypes

postgresql

what is the equivalent of varbinary(10) in postgresql

postgresql sqldatatypes bit-fields

postgresql