Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 4945E2E35BE for ; Tue, 18 Dec 2007 07:07:39 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 88507-08 for ; Tue, 18 Dec 2007 07:07:24 -0400 (AST) Received: from mail.rp-online.de (mail.rp-online.de [149.221.1.199]) by postgresql.org (Postfix) with ESMTP id 514A02E357C for ; Tue, 18 Dec 2007 07:07:30 -0400 (AST) Received: from idefix.d.rp-online.de (idefix.d.rp-online.de [149.221.100.194]) by mail.rp-online.de (Postfix) with ESMTP id 8789D3056C; Tue, 18 Dec 2007 12:07:28 +0100 (CET) From: Thomas Pundt Reply-To: Thomas Pundt Organization: RP Online GmbH To: pgsql-admin@postgresql.org Subject: Re: Dump database more than 1 flat file Date: Tue, 18 Dec 2007 12:08:13 +0100 User-Agent: KMail/1.9.6 (enterprise 20070831.706792) Cc: Alvaro Herrera , "A.Burbello" References: <110808.75802.qm@web36204.mail.mud.yahoo.com> <20071218010511.GE24103@alvh.no-ip.org> In-Reply-To: <20071218010511.GE24103@alvh.no-ip.org> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200712181208.13449.mlists@rp-online.de> X-Anti-Virus: Kaspersky Anti-Virus for MailServers 5.5.10/RELEASE, bases: 18122007 #455141, status: clean X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200712/165 X-Sequence-Number: 27682 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 ---- http://rp-online.de/ ----