0
0

Delete article

Deleted articles cannot be recovered.

Draft of this article would be also deleted.

Are you sure you want to delete this article?

More than 3 years have passed since last update.

PostgreSQL メモ

Last updated at Posted at 2021-08-20

PostgreSQLを起動。

$ brew services start postgresql

起動出来たか確認。

$ brew services list

postgres(databaseの名前)に入る

$ psql postgres

postgres(userの名前)を作成

postgres=# create user postgres SUPERUSER;

sampleって名前のdatabase作成

postgres=# create database sample owner=postgres;

作ったら、exitで一度抜けてpostgres(ユーザ名)でsample(DB名)に入りなおす。

psql sample -U postgres

PostgreSQLを停止。

brew services stop postgresql
0
0
0

Register as a new user and use Qiita more conveniently

  1. You get articles that match your needs
  2. You can efficiently read back useful information
  3. You can use dark theme
What you can do with signing up
0
0

Delete article

Deleted articles cannot be recovered.

Draft of this article would be also deleted.

Are you sure you want to delete this article?