4,348
edits
mNo edit summary |
|||
(4 intermediate revisions by the same user not shown) | |||
Line 90: | Line 90: | ||
$ createdb -O puser appdb | $ createdb -O puser appdb | ||
</syntaxhighlight> | </syntaxhighlight> | ||
= Usage = | = Usage = | ||
Line 97: | Line 98: | ||
<syntaxhighlight lang="bash"> | <syntaxhighlight lang="bash"> | ||
$ sudo -iu puser | $ sudo -iu puser | ||
$ | $ psql -d appdata -U puser | ||
</syntaxhighlight> | </syntaxhighlight> | ||
Line 118: | Line 119: | ||
| class="cli" | \q || Quit || | | class="cli" | \q || Quit || | ||
|- | |- | ||
| class="cli" | \conninfo || Get connection information || | | class="cli" | \conninfo || Connection information || Get current connection information | ||
|- | |||
| class="cli" | \d || List || List tables, views, and sequences | |||
|- | |- | ||
| | | class="cli" | \dt || List tables || | ||
|} | |} | ||
<syntaxhighlight lang="bash"> | <syntaxhighlight lang="bash"> | ||
</syntaxhighlight> | </syntaxhighlight> | ||
= Resources = | = Resources = | ||
[[Introduction to PostgreSQL for MySQL Users]] | [[Introduction to PostgreSQL for MySQL Users]] |