CentOS Question posted in
The official documentation can be found here.

Extract specific alphabetic characters using SQL query – CentOS

Background: I am using PostgreSQL 11 on CentOS. I have a database having UTF-8 encoding, in specific tables I have some Latin characters as follows [ÄéÒçòý]

Objective: I want to replace those with standard English characters for that I am trying to use the following query to list down those specific characters but getting all characters set :

SELECT name_0 from public.gadm36_0_iso2_iso3 where name_0 ~ '[[:alpha:]]';

enter image description here

I am searching on my side and referring to some posts as well.

Any help/any suggestions would be great !!!

Tags:

2

Answers


  1. 0

    Perhaps you are looking for unaccent:

    CREATE EXTENSION unaccent;

SELECT unaccent('ÄéÒçòý');

 unaccent 
----------
 AeOcoy
(1 row)
    Login or Signup to reply.
  2. 0

    You can use regular expressions for this

    SELECT 'ÄéÒçòý' ~* 'A[A-Z0-9]*Z';

    The output should be false for the above SQL statement. So use this in your where clause.

    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search