Skip site navigation (1) Skip section navigation (2)

RE: Capturing all output from psql into a file

From: "Tamsin" <tamsin(at)bryncadfan(dot)co(dot)uk>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: RE: Capturing all output from psql into a file
Date: 2000-12-20 09:07:50
Message-ID: NEBBKHBOBMJCHDMGKCNJKEJICHAA.tamsin@bryncadfan.co.uk (view raw or flat)
Thread:
Lists: pgsql-novice
I use this:

psql dbname -c "\i sqlscript.txt" &> file.txt

(enter at shell prompt rather than going into psql first)

Hope this helps,
Tamsin


> -----Original Message-----
> From: pgsql-novice-owner(at)postgresql(dot)org
> [mailto:pgsql-novice-owner(at)postgresql(dot)org]On Behalf Of Huy Do
> Sent: 20 December 2000 05:37
> To: pgsql-novice(at)postgresql(dot)org
> Subject: [NOVICE] Capturing all output from psql into a file
> 
> 
> Hi,
> 
> I am doing this mass table creation (approx 600 tables) and then
> mass dump of records into these tables (~900megs of flat files).
> 
> All the table creation and record copy is being done from a file
> using \i sqlscript.txt.
> 
> How can I capture all the output which comes out from psql. I need
> all the errors and not just the query result.
> 
> I have tried to use \o file.txt and \g file.txt but they only
> seem to output the query result.
> 
> Many thanks.
> 
> Huy
> 

In response to

Responses

pgsql-novice by date

Next:From: Fred AccaryDate: 2000-12-20 10:10:31
Subject: plpgsql not unrecognized
Previous:From: Huy DoDate: 2000-12-20 05:37:12
Subject: Capturing all output from psql into a file

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group