How to check for column attributes in postgreSQL?

I am new to SQL. Let say that when someone created a table like this in database named test1 of PostgreSQL:

CREATE TABLE users (
    id SERIAL PRIMARY KEY,
    created_at TIMESTAMP WITH TIME ZONE DEFAULT CURRENT_TIME,
    updated_at TIMESTAMP DEFAULT CURRENT_TIME,
    contents VARCHAR(240) NOT NULL);

​x
 
CREATE TABLE users (    id SERIAL PRIMARY KEY,    created_at TIMESTAMP WITH TIME ZONE DEFAULT CURRENT_TIME,    updated_at TIMESTAMP DEFAULT CURRENT_TIME,    contents VARCHAR(240) NOT NULL);​

I make a query to the database and do not know how data in columns are stored. Is there a query to return the stored definition of the columns in the users table or a method to check this ?

For example: The result should return something like:

id column: SERIAL PRIMARY KEY
created_at: TIMESTAMP WITH TIME ZONE DEFAULT CURRENT_TIME
...

 
id column: SERIAL PRIMARY KEYcreated_at: TIMESTAMP WITH TIME ZONE DEFAULT CURRENT_TIME...​

Answer

You can use information_schema for this

select * 
from information_schema.columns 
where table_name = 'users'

 
select * from information_schema.columns where table_name = 'users'​

Advertisement

Answer