[EMAIL PROTECTED] writes: > Hello, > > I'm trying to change the usal "|" table field separator from the shell > command line: > psql -d ect -f pl_lost.sql -o pl_lost.out.txt -F "\t" -U asaadmin > > But it doesn't work. It keeps the same "|" separator in the output > file. > Can anyone please help me? > I need to output to a tab separated file. Can anynone hel me with this? > > Thanks in advance,
Changing the field separator only works with unaligned output. You need to add a -A to your command line switches (or --no-align). Doing this, though, drops the column headers. -- Remove -42 for email ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
