Postgres Pro
Downloads
Home   >   mailing lists

Re: reading command from file - Mailing list pgsql-novice

From Devinder K Rajput
Subject Re: reading command from file
Date
Msg-id OF64A2336D.152A02AB-ON86256CB0.0000C378@ipaper.com
Whole thread Raw
In response to reading command from file  ("Rosta Farzan" <rosta@acc.csuhayward.edu>)
Responses Re: reading command from file  ("Rosta Farzan" <rosta@acc.csuhayward.edu>)
List pgsql-novice
Tree view

Hi Rosta,

try:
 psql db_name < file_name

regards,

Devinder Rajput
Stores Division Corporate Offices
Chicago, IL
(773) 442-6474


"Rosta Farzan" <rosta@sn432s03.sci.csuhayward.edu>
Sent by: pgsql-novice-owner@postgresql.org

01/15/2003 03:50 PM

       
        To:        pgsql-novice@postgresql.org
        cc:        
        Subject:        [NOVICE] reading command from file



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@acc.csuhayward.edu
(510) 885-4026
*************************************



---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org



pgsql-novice by date:

Previous
From: Steve Crawford
Date:
Subject: Re: reading command from file
Next
From: "Brian Johnson"
Date:
Subject: Insert from CSV (comma separated values) file