Postgres Pro
Downloads
Home   >   mailing lists

Thread: Setting the table separator in psql command mode

Setting the table separator in psql command mode

From
Mehrdad Ghassempoory
Date:
I am trying to set up the table separator (Default "|") to TAB
caharcter.

I have tried :

\f\t
\f \t
\f '\t'

Without any luck.
How is it done?

Re: [GENERAL] Setting the table separator in psql command mode

From
Herouth Maoz
Date:
At 15:59 +0300 on 9/6/98, Mehrdad Ghassempoory wrote:


> I am trying to set up the table separator (Default "|") to TAB
> caharcter.
>
> I have tried :
>
> \f\t
> \f \t
> \f '\t'
>
> Without any luck.
> How is it done?

Seems impossible, for some reason. Why do you want to do that? The header
separator will be misaligned with the fields.

If you just want the data separated by tabs, you can use \copy. If you want
only some of the data, you can select it into a temporary table and then
use \copy.

Herouth

--
Herouth Maoz, Internet developer.
Open University of Israel - Telem project
http://telem.openu.ac.il/~herutma

Re: [GENERAL] Setting the table separator in psql command mode

From
JohnDz
Date:
Mehrdad Ghassempoory wrote:
>
> I am trying to set up the table separator (Default "|") to TAB
> caharcter.
>
> I have tried :
>
> \f\t
> \f \t
> \f '\t'
>
> Without any luck.
> How is it done?

I found that the following works:

psql -F '    ' yourdatabasename

where a tab character is inserted in between the ' '



--
-----------------------------------------------------------------
|John Dzilvelis                                                 |
-----------------------------------------------------------------

Re: [GENERAL] Setting the table separator in psql command mode

From
"Jose' Soares Da Silva"
Date:
On Tue, 9 Jun 1998, Mehrdad Ghassempoory wrote:

> I am trying to set up the table separator (Default "|") to TAB
> caharcter.
>
> I have tried :
>
> \f\t
> \f \t
> \f '\t'
>
> Without any luck.
> How is it done?
Try psql -F"    "
            ^^^^ this mean ^I

       Jose'

Re: [GENERAL] Setting the table separator in psql command mode

From
Bruce Momjian
Date:
>
> Mehrdad Ghassempoory wrote:
> >
> > I am trying to set up the table separator (Default "|") to TAB
> > caharcter.
> >
> > I have tried :
> >
> > \f\t
> > \f \t
> > \f '\t'
> >
> > Without any luck.
> > How is it done?
>
> I found that the following works:
>
> psql -F '    ' yourdatabasename
>
> where a tab character is inserted in between the ' '

6.4 will have this working as your originally expected.

--
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)

HELP

From
Ricardo Romero
Date:
Somebody, HELP-ME PLEASE.

Tks, Romero

Using FreeBSD 2.2.5, postgreSQL 6.3.2

When i connect to PostgreSQL with pgsql ( user ) everything is fine.

But with root, no chances.

# who am i
root     ttyp2   Jun 10 18:54   (:0.0)
# perl romero.pl
Can't load '/usr/local/lib/perl5/site_perl/i386-freebsd/auto/Pg/Pg.so' for
module Pg: Can't find shared library "libpq.so.1.1" at
/usr/local/lib/perl5/i386-freebsd/5.00404/DynaLoader.pm line 166.

 at romero.pl line 3
BEGIN failed--compilation aborted at romero.pl line 3.
# cat romero.pl
#!/usr/local/bin/perl -w

use Pg;

$conn = Pg::connectdb("dbname=template1");
if(!$conn) {
print "Houve erro\n";
exit(1);
}


print "Vou fazer a query \n\n";
Pg::doQuery($conn, "select eu from eumesmo",\@ary);
print "Fiz a query \n\n";

#Pg::doQuery($conn, "select eu from eumesmo", \@ary);

#write;

 for $j ( 0 .. $#ary ) {
             print "Ai o que voce queria garotinho : $ary[$j][00]\n";
 }

#$tot=$#ary+1;
$~ = 'PIEDE';
#write;

exit(0);
# psql template1
ld.so failed: Can't find shared library "libpq.so.1.1"
#