Postgres: Tips on navigating with the command line
I am very new to Postgres and the main problem I have now is that I don't have an overview of my server. If you use something like pgadmin3 it's easy to browse and to get a general idea of the structure of the database.
So looking for some genera开发者_运维问答l commands that could help me discover my database server.
Very basic commands:
Connect to database with client console
psql dbname
Dump db tables
\d
Dump a table schema
\d table
List table content
select * from table
General help
\?
Source/Further info: https://www.postgresql.org/docs/current/static/app-psql.html
精彩评论