Home > mailing lists

Re: char column with a single space as the default not working - Mailing list pgsql-admin

From	David G. Johnston
Subject	Re: char column with a single space as the default not working
Date	November 30, 2023 18:51:58
Msg-id	CAKFQuwYv5AJZ5rutox-09EbJ61Uk8q+3gXPZ2BKAe0zZof-Jwg@mail.gmail.com Whole thread Raw
In response to	char column with a single space as the default not working (Sbob <sbob@quadratum-braccas.com>)
List	pgsql-admin

On Thu, Nov 30, 2023 at 8:34 AM Sbob <sbob@quadratum-braccas.com> wrote:

Thoughts? Is it possible to add a single space to a char column without
it getting truncated?

Just don't use char as a data type and things will behave as you expect.

David J.

From: ROHIT SACHDEVA
Date: 30 November 2023, 18:45:08
Subject: Re: Related to Foreign Table Accessing

From: Peter Gram
Date: 30 November 2023, 20:44:34
Subject: Re: char column with a single space as the default not working