LoginSignup
7
12

More than 5 years have passed since last update.

@tomotaka_ito(Tomotaka Ito)inStudio Ousia

RedShiftでテーブル定義を確認する

Posted at
やりかた
SELECT * FROM pg_table_def WHERE tablename = 'my_table';
  • distkeyがtならdistkeyとして設定されている
  • sortkeyが1とか2ならその順番でsortkeyが設定されている
7
12
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
Sign upLogin
7
12