Received: from finch-post-10.mail.demon.net (finch-post-10.mail.demon.net [194.217.242.38]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f4PIYIA67746 for ; Fri, 25 May 2001 14:34:18 -0400 (EDT) (envelope-from dev@archonet.com) Received: from mwynhau.demon.co.uk ([193.237.186.96] helo=mainbox.archonet.com) by finch-post-10.mail.demon.net with esmtp (Exim 2.12 #1) id 153MPg-0008xU-0A; Fri, 25 May 2001 18:34:16 +0000 Received: from client (client.archonet.com [192.168.1.16]) by mainbox.archonet.com (Postfix) with SMTP id 5FFCF132A3; Fri, 25 May 2001 19:19:52 +0100 (BST) Message-ID: <006501c0e547$49a89e80$1001a8c0@archonet.com> From: "Richard Huxton" To: "Milen" , References: <01C0E51F.F2E673F0.milend@ansco.com> Subject: Re: batch file Date: Fri, 25 May 2001 19:19:47 +0100 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.50.4133.2400 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400 X-Archive-Number: 200105/280 X-Sequence-Number: 3108 From: "Milen" > I want to execute several SQL statements one after another. > Does anyone know if it is possible to create something like a "batch file" > which contains all SQL commands I want. You can do exactly that. Use "man psql" to find out about the -f option or the \i option. - Richard Huxton