Re: reading command from file

Поиск
Список
Период
Сортировка
От Devinder K Rajput
Тема Re: reading command from file
Дата
Msg-id OF64A2336D.152A02AB-ON86256CB0.0000C378@ipaper.com
обсуждение исходный текст
Ответ на reading command from file  ("Rosta Farzan" <rosta@acc.csuhayward.edu>)
Ответы Re: reading command from file  ("Rosta Farzan" <rosta@acc.csuhayward.edu>)
Список pgsql-novice

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 по дате отправления:

Предыдущее
От: Steve Crawford
Дата:
Сообщение: Re: reading command from file
Следующее
От: "Brian Johnson"
Дата:
Сообщение: Insert from CSV (comma separated values) file