postgresqlのユーザ確認

hackkit:~# su – postgres

postgres@hackkit:~$ psql

Welcome to psql 8.1.18, the PostgreSQL interactive terminal.

Type:  ¥copyright for distribution terms

¥h for help with SQL commands

¥? for help with psql commands

¥g or terminate with semicolon to execute query

¥q to quit

postgres=# ¥du

List of roles

Role name | Superuser | Create role | Create DB | Connections | Member of

———–+———–+————-+———–+————-+———–

keitai    | yes       | yes         | yes       | no limit    |

postgres  | yes       | yes         | yes       | no limit    |

(2 rows)

postgres=# ¥q

postgres@hackkit:~$

タイトルとURLをコピーしました