how to load a sql-file????

From: markus jais <mjais(at)web(dot)de>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: how to load a sql-file????
Date: 2001-03-27 21:42:39
Message-ID: 3AC1094F.63A28661@web.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

hi,
maybe this is somewhere in the docs but I couldn't find
it.
I am a beginner to postgresql and do not know much till now.
I have bought a book on SQL and now I want to
import the sample databases into postgresql
they are provided as *.sql.

in MySQL I can type something like in Bash on my linux box:

$ mysql -u root -p < file.sql

then the file file.sql is read.

can you tell me how to do this with postgresql???
thanks a lot.

markus

--
Markus Jais
http://www.mjais.de
info(at)mjais(dot)de
The road goes ever on and on - Bilbo Baggins

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Rich Shepard 2001-03-27 22:09:08 Alternate data locations
Previous Message Cedar Cox 2001-03-27 21:12:44 Re: PostgreSQL and PHP - some Great Bridge news