Re: input from a file

From: Joel Burton <jburton(at)scw(dot)org>
To: "Stephen M(dot) Ford" <sford(at)Eng(dot)Auburn(dot)EDU>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: input from a file
Date: 2001-05-03 18:46:45
Message-ID: Pine.LNX.4.21.0105031445510.5476-100000@olympus.scw.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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(at)scw(dot)org>
Director of Information Systems, Support Center of Washington

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Eric Naujock 2001-05-03 19:17:20 Re: input from a file
Previous Message Peter J. Schoenster 2001-05-03 16:39:49 what is: idle in transaction