Re: Need Help in creating script

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