| From: | "Scott Marlowe" <smarlowe(at)qwest(dot)net> |
|---|---|
| To: | "Pradeepkumar, Pyatalo (IE10)" <Pradeepkumar(dot)Pyatalo(at)honeywell(dot)com> |
| Cc: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: help on automatically running sql files |
| Date: | 2004-08-31 07:57:04 |
| Message-ID: | 1093939024.5493.62.camel@localhost.localdomain |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
On Tue, 2004-08-31 at 01:33, Pradeepkumar, Pyatalo (IE10) wrote:
> Hi all,
> For the project that I am working on , we are using Postgresql 7.4.3 on
> Linux 7.2. We have all the database tables,triggers and stored procedures as
> seperate .sql files which we want to ship as part of our software. Now when
> the user installs our software, we need to check if postmaster service is
> running or not and if it is running, then we have to run the sql files
> automatically. Can anyone help me out on how to run the .sql files
> automatically.
Something like psql dbname <sqlfile.sql will do. If psql isn't in the
path, then /path/to/psql dbname <sqlfile.sql
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Pradeepkumar, Pyatalo (IE10) | 2004-08-31 08:40:26 | Re: help on automatically running sql files |
| Previous Message | Pradeepkumar, Pyatalo (IE10) | 2004-08-31 07:33:40 | help on automatically running sql files |