postgres Psql

postgres.txt

#login as superuser into postgres super user
.\psql.exe -u postgres 

#show all database
\l

#change the current database to the one that you want to show tables:
\c testDb

# command from the PostgreSQL command prompt to show tables in the selected database:
# (+ :will add the size and description columns)
\dt+ 

# show details of a specific table, you can specify the name of the table after the \d command:
\d+ table_name

#Query
SELECT * FROM table_name order by id desc limit 100;