Differences
This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision Last revision Both sides next revision | ||
postgresql [2008/07/14 16:13] a |
postgresql [2009/05/25 00:35] 127.0.0.1 external edit |
||
---|---|---|---|
Line 24: | Line 24: | ||
You can also do this for a passwordless user: % crateuser bork | You can also do this for a passwordless user: % crateuser bork | ||
+ | |||
+ | **Creating a new user** | ||
+ | |||
+ | | ||
+ | |||
+ | **creating a new database** | ||
+ | |||
+ | | ||
+ | |||
+ | **changing postgsql user password** \\ | ||
+ | |||
+ | as postgres user (su - postgres) do: | ||
+ | < | ||
+ | $ psql template1 | ||
+ | |||
+ | | ||
+ | |||
+ | | ||
+ | \h for help with SQL commands | ||
+ | \? for help on internal slash commands | ||
+ | \g or terminate with semicolon to execute query | ||
+ | \q to quit | ||
+ | |||
+ | template1=# ALTER USER < | ||
+ | </ | ||
+ | |||
+ | **changeing ownership of database** | ||
+ | |||
+ | | ||
**Inserting a time column** \\ | **Inserting a time column** \\ |