Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps
 (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256)
	(Exim 4.89)
	(envelope-from <pgsql-sql-owner+archive@lists.postgresql.org>)
	id 1fC4Xc-0007yU-HX
	for pgsql-sql@arkaria.postgresql.org; Fri, 27 Apr 2018 14:40:04 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.89)
	(envelope-from <pgsql-sql-owner+archive@lists.postgresql.org>)
	id 1fC4XZ-000284-PM
	for pgsql-sql@arkaria.postgresql.org; Fri, 27 Apr 2018 14:40:01 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
	by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256)
	(Exim 4.89)
	(envelope-from <emilu@encs.concordia.ca>)
	id 1fC4XZ-00027o-Ib
	for pgsql-sql@lists.postgresql.org; Fri, 27 Apr 2018 14:40:01 +0000
Received: from oldperseverance.encs.concordia.ca ([132.205.96.92])
	by magus.postgresql.org with esmtp (Exim 4.89)
	(envelope-from <emilu@encs.concordia.ca>)
	id 1fC4XW-0006k3-AT
	for pgsql-sql@postgresql.org; Fri, 27 Apr 2018 14:40:01 +0000
Received: from cacao.encs.concordia.ca (emilu@cacao.encs.concordia.ca
 [132.205.47.225] port 1713)
	by oldperseverance.encs.concordia.ca (envelope-from emilu@encs.concordia.ca)
 (8.13.7/8.13.7) with ESMTP id w3REdsYI015833
	for <pgsql-sql@postgresql.org>; Fri, 27 Apr 2018 10:39:54 -0400
Reply-To: emilu@encs.concordia.ca
To: pgsql-sql@postgresql.org
From: Emi <emilu@encs.concordia.ca>
Subject: psql method (initcap and also keep Roman number capitalized)
Message-ID: <2bdf8140-48a0-24fc-acd4-14739b973357@encs.concordia.ca>
Date: Fri, 27 Apr 2018 10:39:54 -0400
User-Agent: Mozilla/5.0 (X11; Linux i686 on x86_64; rv:45.0) Gecko/20100101
 Thunderbird/45.8.0
MIME-Version: 1.0
Content-Type: multipart/alternative;
 boundary="------------F44C0D83096B725B628F0040"
X-Scanned-By: MIMEDefang 2.58 on oldperseverance.encs.concordia.ca at
 2018-04-27 10:39:54 EDT
List-Id: <pgsql-sql.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-sql@lists.postgresql.org>
List-Owner: <mailto:pgsql-sql-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-sql>
Precedence: bulk

This is a multi-part message in MIME format.
--------------F44C0D83096B725B628F0040
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 7bit

Hello,

May I know is there a psql method that can do similar to initcap, and 
could also keep Roman numbers (II, IV, VI, etc) to be capitalized please?

For example, string shows "Title II" but not "Title Ii".

Thanks a lot.

--------------F44C0D83096B725B628F0040
Content-Type: text/html; charset=utf-8
Content-Transfer-Encoding: 7bit

<html>
  <head>

    <meta http-equiv="content-type" content="text/html; charset=utf-8">
  </head>
  <body bgcolor="#FFFFFF" text="#000000">
    <font size="-2">Hello,<br>
      <br>
      May I know is there a psql method that can do similar to initcap,
      and could also keep Roman numbers (II, IV, VI, etc) to be
      capitalized please?<br>
      <br>
      For example, string shows "Title II" but not "Title Ii".<br>
      <br>
      Thanks a lot.<br>
    </font>
  </body>
</html>

--------------F44C0D83096B725B628F0040--