Re: multiple psql commands in batch

ok, but when I have a batch file like this:
>>>
@echo off

C:\postgresdir\pgsql\bin\psql.exe -U postgres
CREATE DATABASE mydatabase;
CREATE USER mydbuser PASSWORD 'mypwd';
<<<

i can't get it to run. How do i set SQL-commands in this case?

> -------- Original-Nachricht --------
> Datum: Sat, 3 Jun 2006 10:48:57 +1200
> Von: Andrej Ricnik-Bay <andrej(dot)groups(at)gmail(dot)com>
> An: Tobias Boes <tobias(dot)boes(at)gmx(dot)de>
> Betreff: Re: [NOVICE] multiple psql commands in batch
>
> Something like:
>
> create database
> \connect database user
> create table ....
>
> Cheers,
> Andrej
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
> http://archives.postgresql.org

--

Der GMX SmartSurfer hilft bis zu 70% Ihrer Onlinekosten zu sparen!
Ideal für Modem und ISDN: http://www.gmx.net/de/go/smartsurfer