| From: | Rich Shepard <rshepard(at)appl-ecosys(dot)com> |
|---|---|
| To: | missive(at)hotmail(dot)com |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: batch file |
| Date: | 2002-02-21 04:31:59 |
| Message-ID: | Pine.LNX.4.44.0202202030500.17036-100000@salmo.appl-ecosys.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Thu, 21 Feb 2002, Lee Harr wrote:
> > 2. Which command in psql should I use to read in suc a file
>
> \i commands.sql
Or, use 'psql -f <filename>'. You can also use the '-d' switch to specify
the database to use. I just learned all this earlier this week and it works
like a charm.
Rich
Dr. Richard B. Shepard, President
Applied Ecosystem Services, Inc. (TM)
2404 SW 22nd Street | Troutdale, OR 97060-1247 | U.S.A.
+ 1 503-667-4517 (voice) | + 1 503-667-8863 (fax) | rshepard(at)appl-ecosys(dot)com
http://www.appl-ecosys.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Gregory Wood | 2002-02-21 05:48:18 | Re: entering empty value |
| Previous Message | paul simdars | 2002-02-21 03:51:16 | Re: OID - insert statement |