Re: Dump database more than 1 flat file - Mailing list pgsql-admin

From Thomas Pundt
Subject Re: Dump database more than 1 flat file
Date
Msg-id 200712181208.13449.mlists@rp-online.de
Whole thread Raw
In response to Re: Dump database more than 1 flat file  (Alvaro Herrera <alvherre@commandprompt.com>)
List pgsql-admin
Hi,

On Dienstag, 18. Dezember 2007, Alvaro Herrera wrote:
| A.Burbello wrote:
| > If doesn't have another way, how can I put the
| > "header" in the begin of file without open?
| > With "cat >>" command I put in the end.
|
| Don't -- you can put the header in a separate file and do something like
|
| (cat header-file ; cat split-1 ; cat tail-file ) | psql

even simpler: "cat" usually takes any number of file name arguments,
so usually you simply can do

  cat header-file split-1 tail-file | psql

No need for parentheses and starting a new process for each file.

Ciao,
Thomas

--
Thomas Pundt <thomas.pundt@rp-online.de> ---- http://rp-online.de/ ----

pgsql-admin by date:

Previous
From: "Milen A. Radev"
Date:
Subject: Re: Querying
Next
From: Sören Kress
Date:
Subject: PITR and modification of the backup database