Received: from web10005.mail.yahoo.com (web10005.mail.yahoo.com [216.136.130.41]) by postgresql.org (8.11.3/8.11.1) with SMTP id f4PHrZA17772 for ; Fri, 25 May 2001 13:53:35 -0400 (EDT) (envelope-from jdearl@yahoo.com) Message-ID: <20010525175334.29272.qmail@web10005.mail.yahoo.com> Received: from [12.18.144.101] by web10005.mail.yahoo.com; Fri, 25 May 2001 10:53:34 PDT Date: Fri, 25 May 2001 10:53:34 -0700 (PDT) From: Jason Earl Subject: Re: batch file To: Milen , "'pgsql-sql@postgresql.org.'" In-Reply-To: <01C0E51F.F2E673F0.milend@ansco.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Archive-Number: 200105/277 X-Sequence-Number: 3105 I just put files commands that I want in some file like "foo.sql" and then do: psql mydatabase -f foo.sql Is this what you are looking for? Jason --- Milen wrote: > Hi all!, > > 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. > > Best Regards: > Milen > > ---------------------------(end of > broadcast)--------------------------- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/users-lounge/docs/faq.html __________________________________________________ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/