Message-ID: <443cd7906ebe9a96b2f635b4dc33fa93534978dd.camel@cybertec.at>
Subject: Re: PostgreSQL appears to truncate column alias names after 31
 characters.
From: Laurenz Albe <laurenz.albe@cybertec.at>
To: Manish Singh <manish.singh@india.corelynx.com>,
	pgsql-bugs@lists.postgresql.org
Date: Tue, 01 Oct 2024 10:40:46 +0200
In-Reply-To: 
 <1158363234.5085080.1727766363469.JavaMail.zimbra@india.corelynx.com>
References: 
	<1158363234.5085080.1727766363469.JavaMail.zimbra@india.corelynx.com>
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
User-Agent: Evolution 3.52.4 (3.52.4-1.fc40) 
MIME-Version: 1.0
Archived-At: 
 <https://www.postgresql.org/message-id/443cd7906ebe9a96b2f635b4dc33fa93534978dd.camel%40cybertec.at>
Precedence: bulk

On Tue, 2024-10-01 at 07:06 +0000, Manish Singh wrote:
> I am using pgsql with laravel.I have noticed that PostgreSQL appears to t=
runcate column alias names
> after 31 characters.
>=20
> For example (this is from the psql command-line tool):
>=20
> SELECT rss_headline_id as abcdefghijklmno pqrstuvwxyz1234 56, title, url
> FROM news_rss_headli nes headlines WHERE rss_headline_id =3D 22833;
> NOTICE: identifier "abcdefghijklmn opqrstuvwxyz123 456" will be
> truncated to "abcdefghijklmn opqrstuvwxyz123 45"

I cannot reproduce that.
Unless you modify the source, identifiers will be cut off after 63 bytes
(NAMEDATALEN - 1; one byte is for the terminating zero byte).

Did you modify the source?
Also, the spaces in your identifier should cause a syntax error.
Can you explain why you don't get such an error?

Yours,
Laurenz Albe