On Tue, Jun 4, 2019 at 3:30 PM Lou <l...@dayspringpublisher.com> wrote:
> Is it possible to convert a boolean yes or no field to hold a one letter > string? For example, the strings: 's' 'f' 'p' 'e' > Something like the following should work: ALTER TABLE ... ALTER COLUMN ... TYPE text USING (CASE WHEN ... THEN 's' ELSE 'f' END); https://www.postgresql.org/docs/11/sql-altertable.html Though at this point you are probably better off creating a category table with a primary key and converting this column to be a foreign key. David J.