开发者

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

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜