2 個答案
- 最新
- 最多得票
- 最多評論
0
Hi larryq,
I'll refer you to the doc. page that has most of what you need here: https://docs.aws.amazon.com/redshift/latest/dg/r_CREATE_TABLE_NEW.html
If the PostgreSQL DB is the true source for this data then I recommend the following:
- BIGSERIAL -> BIGINT as they are both INT8. If you source the rows from PostgreSQL you don't need the auto generating value creation of BIGSERIAL in Redshift. Otherwise Redshift has the IDENTITY column attribute to generate values.
- JSON -> VARCHAR. Of course you'll have to use Redshift's JSON function to do anything with the JSON data.
Regards,
-Kurt
已回答 4 年前
相關內容
- AWS 官方已更新 1 年前