PostgreSQLでよくやることのソースを表示

== database ==
一覧
<syntaxhighlight lang="sql">
# \l
</syntaxhighlight>
切り替え
<syntaxhighlight lang="sql">
# \c <DABASE_NAME>
</syntaxhighlight>
作成
<syntaxhighlight lang="sql">
# create database  <DABASE_NAME>;
</syntaxhighlight>
<syntaxhighlight lang="sql">
# create database <DABASE_NAME> owner <OWNER_NAME>;
</syntaxhighlight>
削除
<syntaxhighlight lang="sql">
# drop database <DATABASE_NAME>;
</syntaxhighlight>


== table ==
一覧（viewとかも）
<syntaxhighlight lang="sql">
# \d
</syntaxhighlight>
一覧（tableだけ）
<syntaxhighlight lang="sql">
# \dt
</syntaxhighlight>
削除
<syntaxhighlight lang="sql">
# drop table <TABLE_NAME>;
</syntaxhighlight>

== schema ==
一覧
<syntaxhighlight lang="sql">
# \dn
</syntaxhighlight>
確認
<syntaxhighlight lang="sql">
# select current_schema;
</syntaxhighlight>
変更
<syntaxhighlight lang="sql">
# set search_path to <SCHEMA_NAME>;
</syntaxhighlight>


[[Category:PostgreSQL]]
[[Category:Database]]