Re: batch file - Mailing list pgsql-general

From missive@frontiernet.net (Lee Harr)
Subject Re: batch file
Date
Msg-id slrna78r85.75.missive@whave.frontiernet.net
Whole thread Raw
Responses Re: batch file
List pgsql-general
> In the postgresql tutorial it is explained how to enter commands one by
> one, I was wondering whether it is possible to first put a series of
> commands in an ascii file and then read in that file with psql. Here are
> my questions:
> 1. What should be the default extension of such a file

I do not know of a standard. How about .sql ?

> 2. Which command in psql should I use to read in suc a file

\i commands.sql

Also, take a look at \? which will show you other goodies.



pgsql-general by date:

Previous
From: "paul simdars"
Date:
Subject: Re: OID - insert statement
Next
From: missive@frontiernet.net (Lee Harr)
Date:
Subject: Re: deleting an identical record