equal
deleted
inserted
replaced
21 Connect as user ``mypguser`` to new database:: |
21 Connect as user ``mypguser`` to new database:: |
22 |
22 |
23 $ su - mypguser |
23 $ su - mypguser |
24 $ psql mypgdatabase |
24 $ psql mypgdatabase |
25 |
25 |
|
26 In order to create local host superuser:: |
|
27 |
|
28 $ sudo su - postgres |
|
29 $ createuser --superuser USER |
|
30 $ exit |
|
31 $ sudo -u USER psql |
|
32 |
26 .. |
33 .. |
27 |
34 |
28 https://wiki.debian.org/PostgreSql |
35 https://wiki.debian.org/PostgreSql |
29 Debian wiki instructions. |
36 Debian wiki instructions. |
30 |
37 |
31 List databases, schemas and tables. |
38 List databases, schemas and tables. |
32 =================================== |
39 =================================== |
33 |
40 |
34 Default database is ``postgres``. |
41 Default database is ``postgres``. |
35 |
42 |
36 To list databases:: |
43 To list databases and database locales:: |
37 |
44 |
38 $ psql -U pgadmin -l |
45 $ psql -U pgadmin -l |
39 |
46 |
40 or:: |
47 or:: |
41 |
48 |