PostgreSQL 13に型varcharからtextへの変換サンプル

2013年8月28日2022年1月9日

環境
Windows10 64 bit
PostgreSQL 13.2

書式
cast(cast(文字列 as varchar(桁数)) as text)

使い方
varchar文字数指定あり(12桁)からtextへ変換します
操作例1

postgres=# select cast(cast('studyskill' as varchar(12)) as text);

text

------------

studyskill

(1 行)

postgres=# select cast(cast('studyskill' as varchar(12)) as text); text ------------ studyskill (1 行)

postgres=# select cast(cast('studyskill' as varchar(12)) as text);
    text
------------
 studyskill
(1 行)

操作例2

postgres=# select cast(cast('studyskillinarkgame' as varchar(12)) as text);

text

--------------

studyskillin

(1 行)

postgres=# select cast(cast('studyskillinarkgame' as varchar(12)) as text); text -------------- studyskillin (1 行)

postgres=# select cast(cast('studyskillinarkgame' as varchar(12)) as text);
     text
--------------
 studyskillin
(1 行)

Posted by arkgame