From: | "Jackson, DeJuan" <djackson(at)cpsgroup(dot)com> |
---|---|
To: | Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us>, PostgreSQL Questions Mailing List <pgsql-questions(at)postgreSQL(dot)org> |
Cc: | PostgreSQL Hackers Mailing List <pgsql-hackers(at)hub(dot)org> |
Subject: | RE: [QUESTIONS] Using psql \f to change delimiter to space |
Date: | 1998-05-08 16:16:19 |
Message-ID: | F10BB1FAF801D111829B0060971D839F27622A@dal_cps.cpsgroup.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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 |
> >
> > 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?
>
> I just did
>
> \f \
> ^ space here
>
> See:
>
> ----------------------------------------------------------------------
> -----
>
> test=> \f \
> field separator changed to ''
> test=> select * from pg_user
> test-> \g
> usename usesysidusecreatedbusetraceusesuperusecatupdpasswd valuntil
>
> ----------------------------------------------------------------------
> ------------------
> postgres 139t t t t ********Sat Jan 31
> 01:00:00 2037 EST
> (1 row)
>
Sorry to correct you Bruce but that causes the delimiter to be set to
nothing ('') not space (' ').
-DEJ
From | Date | Subject | |
---|---|---|---|
Next Message | Jackson, DeJuan | 1998-05-08 16:19:11 | RE: [QUESTIONS] UInt types |
Previous Message | Jackson, DeJuan | 1998-05-08 16:11:27 | RE: [QUESTIONS] Multiple tables? |