Re: char column with a single space as the default not working

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Sbob <sbob(at)quadratum-braccas(dot)com>
Cc: Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: char column with a single space as the default not working
Date: 2023-11-30 15:51:58
Message-ID: CAKFQuwYv5AJZ5rutox-09EbJ61Uk8q+3gXPZ2BKAe0zZof-Jwg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Thu, Nov 30, 2023 at 8:34 AM Sbob <sbob(at)quadratum-braccas(dot)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.

https://wiki.postgresql.org/wiki/Don%27t_Do_This#Don.27t_use_char.28n.29

David J.

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Peter Gram 2023-11-30 17:44:34 Re: char column with a single space as the default not working
Previous Message ROHIT SACHDEVA 2023-11-30 15:45:08 Re: Related to Foreign Table Accessing