Using char_length( string ) : char_length « String Functions « PostgreSQL

1. PostgreSQL
2. String Functions
3. char_length

Using char_length( string )

postgres=#
postgres=# CREATE TABLE test1 (a character(4));
CREATE TABLE
postgres=#
postgres=# INSERT INTO test1 VALUES ('ok');
INSERT 0 1
postgres=# SELECT a, char_length(a) FROM test1;
  a   | char_length
------+-------------
 ok   |           2
(1 row)

postgres=#
postgres=# drop table test1;
DROP TABLE
postgres=#
postgres=#
           
       

Related examples in the same category