Re: [QUESTIONS] Using psql \f to change delimiter to space

>
> > > 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(at)candle(dot)pha(dot)pa(dot)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)