postgres equivalent's

Góra strony
Załączniki:
Wiadomość jako email
+ (text/plain)
Delete this message
Reply to this message
Autor: Nick Estes
Data:  
Temat: postgres equivalent's
> mysqlshow

If you tell me what it does, I'm sure I could tell you the equivalent (-=


> mysqladmin create <db>


createdb <db>

Simlar programs that come in handy are: dropdb, createuser, and
vacuumdb


> show tables;


\dt

See also: \d to show everything (tables, sequences, etc), there's also a
few others to show other info.


> describe <table>;


\d <table>

    --Nick