Postgres Pro
Downloads
Home   >   mailing lists

Re: input from a file - Mailing list pgsql-novice

From Joel Burton
Subject Re: input from a file
Date
Msg-id Pine.LNX.4.21.0105031445510.5476-100000@olympus.scw.org
Whole thread Raw
In response to input from a file  ("Stephen M. Ford" <sford@Eng.Auburn.EDU>)
List pgsql-novice
Tree view 
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
thosetables.  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

pgsql-novice by date:

Previous
From: "Albert REINER"
Date:
Subject: pl/pgSQL: locale and ~ '[a-z]'
Next
From: "Eric Naujock "
Date:
Subject: Re: input from a file