Re: multiple psql commands in batch - Mailing list pgsql-novice

From Tobias Boes
Subject Re: multiple psql commands in batch
Date
Msg-id 20060603090240.308940@gmx.net
Whole thread Raw
In response to Re: multiple psql commands in batch  ("Andrej Ricnik-Bay" <andrej.groups@gmail.com>)
List pgsql-novice
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.groups@gmail.com>
> An: Tobias Boes <tobias.boes@gmx.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


pgsql-novice by date:

Previous
From: "Andrej Ricnik-Bay"
Date:
Subject: Re: multiple psql commands in batch
Next
From: "Roy W Bradley"
Date:
Subject: Generic/Ad-Hoc Select Function