Re: Using sql statements in file

From: "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com>
To: Suresh Basandra <sureshb(at)warpera(dot)com>
Cc: <pgsql-sql(at)postgresql(dot)org>
Subject: Re: Using sql statements in file
Date: 2003-09-23 16:54:45
Message-ID: Pine.LNX.4.33.0309231054310.12142-100000@css120.ihs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Mon, 22 Sep 2003, Suresh Basandra wrote:

> Hi,
>
> I would like to do the following using files:
>
> 1. put create database, create tables sql statements in a file and
> execute through prompt
> 2. insert or update data that is put in a file
>
> Please let me know if there are any examples that lists how sql
> statements can be put in a file and used.

psql dbnamehere <filename.sql

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2003-09-23 17:18:29 Re: pl/pgsql, cursors and C function
Previous Message Tomasz Myrta 2003-09-23 16:43:12 Re: pl/pgsql, cursors and C function