Re: [QUESTIONS] Using psql \f to change delimiter to space - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: [QUESTIONS] Using psql \f to change delimiter to space
Date
Msg-id 199805081725.NAA09742@candle.pha.pa.us
Whole thread Raw
In response to RE: [QUESTIONS] Using psql \f to change delimiter to space  ("Jackson, DeJuan" <djackson@cpsgroup.com>)
List pgsql-hackers
>
> > > When I invoke psql, the default delimiter is the pipe "|"
> > > character.  I can't find the correct syntax to
> > > change the delimiter back to a single space.  If I
> > > type :
> > > \f <whitespace> -- delimiter stays at |
> > > \f \<whitespace> -- delimiter stays at |
> > >
> >
> Sorry to correct you Bruce but that causes the delimiter to be set to
> nothing ('') not space (' ').

I stand corrected.  This has been asked before, and the only solution I
know is:

    psql -F ' ' testdb

Is that acceptable, or do you want it to work with \f?  The problem is
that the trailing spaces are removed from all command lines, so it is not
seeing the space.

--
Bruce Momjian                          |  830 Blythe Avenue
maillist@candle.pha.pa.us              |  Drexel Hill, Pennsylvania 19026
  +  If your life is a hard drive,     |  (610) 353-9879(w)
  +  Christ can be your backup.        |  (610) 853-3000(h)

pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] Bug in linking in old libraries
Next
From: Bruce Momjian
Date:
Subject: Re: [PATCHES] Try again: S_LOCK reduced contentionh]