Skip site navigation (1) Skip section navigation (2)

Re: postgres import

From: "Albe Laurenz" <all(at)adv(dot)magwien(dot)gv(dot)at>
To: "Antonios Katsikadamos *EXTERN*" <antonioskatsikadamos(at)yahoo(dot)com>,<pgsql-general(at)postgresql(dot)org>
Subject: Re: postgres import
Date: 2006-10-31 08:32:51
Message-ID: 52EF20B2E3209443BC37736D00C3C1380B31A578@EXADV1.host.magwien.gv.at (view raw or flat)
Thread:
Lists: pgsql-general
> I have a little problem. I have an .sql file (  db dump  )  
> and i want to import it to postgres on linux.
>  
> Does anyone know how i can do it?

You feed it to the command line interface psql.

Example:
psql -h host -p port -d database -U user <dump.sql

Yours,
Laurenz Albe

Responses

pgsql-general by date

Next:From: SunWuKungDate: 2006-10-31 09:15:32
Subject: Catch multiple records when doing Select Into
Previous:From: Antonios KatsikadamosDate: 2006-10-31 08:27:02
Subject: postgres import

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group