How to retrieve table attributes in PostgreSQL? [duplicate]

Question

So I'm very new to PostgreSQL (and SQL as a whole) and I'm trying to find a way to view all attributes of a table. For example, say you have a table called "movies", I would like to see what attributes it has (e.g. movie_name, release_year).

I'm sure there is a simple command for it, but I couldn't find it.

Thanks in advance for any help!

GMB · Accepted Answer · 2020-12-05 14:39:19Z

4

Assuming that by attributes you mean columns, a standard approach uses system view information_schema.columns:

select column_name, datatype 
from information_schema.columns 
where table_name = 'mytable'

From a PSQL command line, you can also use \d (which stands for describe):

# \d mytable

answered Dec 5, 2020 at 14:39

GMB

224k25 gold badges103 silver badges151 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to retrieve table attributes in PostgreSQL? [duplicate]

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related