Forwarded to HACKERS list.
-DEJ
> 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 |
>
> Enclosing the space within single or double quotes produces
> a delimiter that actually includes the quotes. I tried
> octal specification \040 for the space which also failed.
>
> Version 6.3.2 on Linux i386 (Redhat 4).
>
> What's the correct syntax?
>
> Marc Zuckman
> marc@fallon.classyad.com
>
> _\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_
> _ Visit The Home and Condo MarketPlace _
> _ http://www.ClassyAd.com _
> _ _
> _ FREE basic property listings/advertisements and searches. _
> _ _
> _ Try our premium, yet inexpensive services for a real _
> _ selling or buying edge! _
> _\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_
>
> --
> Official WWW Site: http://www.postgresql.org
> Online Docs & FAQ: http://www.postgresql.org/docs
> Searchable Lists: http://www.postgresql.org/mhonarc