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

Capturing all output from psql into a file

From: "Huy Do" <huy(at)travel(dot)com(dot)au>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: Capturing all output from psql into a file
Date: 2000-12-20 05:37:12
Message-ID: NEBBIHDFCLBAILBDEADCIECHCAAA.huy@travel.com.au (view raw or flat)
Thread:
Lists: pgsql-novice
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

Responses

pgsql-novice by date

Next:From: TamsinDate: 2000-12-20 09:07:50
Subject: RE: Capturing all output from psql into a file
Previous:From: David MerrillDate: 2000-12-20 05:03:59
Subject: generating uuids

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