Postgresql でカラムの型を配列型に変更

Share on Facebook0Share on Google+0Tweet about this on TwitterShare on LinkedIn0

ALTER TABLE foo_table ALTER COLUMN foo_column TYPE VARCHAR[] USING '{}';

USINGをちゃんとせんとエラーなるのね。

Share on Facebook0Share on Google+0Tweet about this on TwitterShare on LinkedIn0

あわせて読みたい

Fatal error: Uncaught Exception: 12: REST API is deprecated for versions v2.1 and higher (12) thrown in /var/www/junkpot.net/tech/html/wp-content/plugins/seo-facebook-comments/facebook/base_facebook.php on line 1273