Horton

Re: input from a file

Joel Burton <jburton@scw.org>

View thread View on postgr.es
From: Joel Burton <jburton@scw.org>
To: "Stephen M. Ford" <sford@Eng.Auburn.EDU>
Cc: pgsql-novice@postgresql.org
Date: 2001-05-03T18:46:45Z
Lists: pgsql-novice 
On Thu, 3 May 2001, Stephen M. Ford wrote:

> I have a dump from a msql database into a file and would like postgre to build the tables and insert the data into those tables.  How do I go about getting postgre to read commands from a file? 

  psql dbname < yourfile.sql

is always a likely way to pump some data into a Unix program.


-- 
Joel Burton   <jburton@scw.org>
Director of Information Systems, Support Center of Washington