From: | manuel(at)des01(dot)sanyres(dot)es |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: Need Help in creating script |
Date: | 2001-05-17 11:42:41 |
Message-ID: | slrn9g7aso.uuc.manuel@des01.sanyres.es |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
In article <9dutbv$2hdu$2(at)news(dot)tht(dot)net>, Alexander Dederer wrote:
> Prashant Sinha wrote:
>
>> This is a multi-part message in MIME format.
>>
>> ------=_NextPart_000_0021_01C0DE12.BB861C80
>> Content-Type: text/plain; charset="iso-8859-1"
>> Content-Transfer-Encoding: quoted-printable
>>
>> Hi,
>> I am a new postgre user. I had used sql commands to create database and
>> tab= les. Is it possible to create a script or installable version on
>> existing d= atabase which I could run on any machine and it would crearte
>> the database = with all the tables and everything. Can anyone please help
>> me with this? Thanks in advance,
>
> Look programm:
> pg_dump
> pg_dumpall
> psql
>
>
Use pg_dump.
pg_dump <database> > <file>
createdb <newdatabase>
cat <file> | psql <newdatabase>
--
Manuel Cano Muñoz
------------------------------
SANYRES, S.A.
Director Dpto. Sistemas
manuel(at)sanyres(dot)com
manuel(at)sanyres(dot)es
From | Date | Subject | |
---|---|---|---|
Next Message | Didier Bretin | 2001-05-17 14:24:59 | process idle |
Previous Message | SZALAI Karoly | 2001-05-17 08:36:08 | plpgsl or other pl faq |