Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revisionNext revisionBoth sides next revision | ||
labs:postgresql [2009/08/06 17:18] – admin | labs:postgresql [2016/06/27 16:06] – [Creating Sequences] admin | ||
---|---|---|---|
Line 13: | Line 13: | ||
You can use * to mean all columns in the table. | You can use * to mean all columns in the table. | ||
+ | |||
+ | === Explanation of Various Joins === | ||
+ | |||
+ | The picture below comes from [[http:// | ||
+ | |||
+ | {{http:// | ||
+ | |||
==== Insert Statements ==== | ==== Insert Statements ==== | ||
Line 53: | Line 60: | ||
===== Creating Tables ===== | ===== Creating Tables ===== | ||
- | ==== Creating Sequences ==== | + | ===== Creating Sequences |
| | ||
- | ==== Viewing Table Information ==== | + | ===== Viewing Table Information |
You may want to look at a table' | You may want to look at a table' | ||
Line 87: | Line 94: | ||
==== Creating User ==== | ==== Creating User ==== | ||
- | CREATE USER username ; | + | CREATE USER username |
+ | Or | ||
+ | createuser | ||
+ | |||
+ | ==== Adding user to groups ==== | ||
+ | |||
+ | ALTER GROUP groupname ADD user username [, ... ] | ||
==== Granting Permissions ==== | ==== Granting Permissions ==== | ||
Line 118: | Line 131: | ||
pg_dump < | pg_dump < | ||
+ | |||
+ | ==== Connecting to Another Database ('' | ||
+ | |||
+ | \c dbname |