Re: reading command from file

From: Jeffrey Melloy <jmelloy(at)visualdistortion(dot)org>
To: "Rosta Farzan" <rosta(at)acc(dot)csuhayward(dot)edu>
Cc: <pgsql-novice(at)postgresql(dot)org>
Subject: Re: reading command from file
Date: 2003-01-16 00:58:26
Message-ID: 9E6DA7D1-28ED-11D7-B657-000A95765962@visualdistortion.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

\i [filename].
The path is relative to the directory you launch psql from, oddly
enough.

HTH
Jeff
On Wednesday, January 15, 2003, at 03:50 PM, Rosta Farzan wrote:

> Hi everybody
>
> I need help in how to read sql commands from file instead of typing in
> postgres (psql) command line. I mean I have a file which includes for
> example a create table command and I want to load it to postgres
> created
> database. Would you please help me with this.
> Thanks,
> Rosta
>
>
> ************************************
> Rosta Farzan
> Laboratory for Adaptive Hypermedia and Assistive Technologies
> Department of Math and Computer Science CSU Hayward
> rosta(at)acc(dot)csuhayward(dot)edu
> (510) 885-4026
> *************************************
>
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to
> majordomo(at)postgresql(dot)org

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Brian Johnson 2003-01-16 03:50:40 Insert from CSV (comma separated values) file
Previous Message Thorsten Haude 2003-01-16 00:47:47 Re: reading command from file