Re: [SQL] Running a file

From: Kaare Rasmussen <kar(at)webline(dot)dk>
To: psql sql <pgsql-sql(at)postgresql(dot)org>
Cc: psql Admin <pgsql-admin(at)postgresql(dot)org>, psql sql <pgsql-sql(at)postgresql(dot)org>
Subject: Re: [SQL] Running a file
Date: 2000-12-25 14:03:37
Message-ID: 00122515033702.30396@bering
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-sql

> Are you talking about writing external scripts and importing them into
> Postgres in a manner similar to the @ function in SQL*Plus? In psql, you
> can use \i to import scripts to do that.

If it's to be used in shell scripts, it's just as easy to pipe:

psql dbname<create_table.sql

--
Kaare Rasmussen --Linux, spil,-- Tlf: 3816 2582
Kaki Data tshirts, merchandize Fax: 3816 2501
Howitzvej 75 ben 14.00-18.00 Email: kar(at)webline(dot)dk
2000 Frederiksberg Lrdag 11.00-17.00 Web: www.suse.dk

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2000-12-25 17:47:11 Re: [BUGS] postgres bombs for continous selects....
Previous Message Dronamraju Rajesh 2000-12-25 12:24:49 postgres bombs for continous selects....

Browse pgsql-sql by date

  From Date Subject
Next Message Narayanan Palasseri 2000-12-27 09:21:51 Sql92..
Previous Message Brett W. McCoy 2000-12-24 17:24:21 Re: [SQL] Running a file