开发者

Is it possibly to specify Postgres column storage type at table creation?

开发者 https://www.devze.com 2023-04-03 14:16 出处:网络
Can one specify the EXTENDED storage type for a column as part开发者_如何学运维 of CREATE TABLE?If yes, would it also work under Postgres 8.1?

Can one specify the EXTENDED storage type for a column as part开发者_如何学运维 of CREATE TABLE? If yes, would it also work under Postgres 8.1?

I don't see a way to do this except through ALTER TABLE, which seems weird for something that really belongs with the rest of the table definition.


I don' think you can.

http://www.postgresql.org/docs/9.1/static/storage-toast.html

"Each TOAST-able data type specifies a default strategy for columns of that data type, but the strategy for a given table column can be altered with ALTER TABLE SET STORAGE."

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号