On Thu, 2009-05-28 at 16:43 +0100, Grzegorz Jaśkiewicz wrote:
> On Thu, May 28, 2009 at 4:24 PM, <inf200468@ucf.edu.cu> wrote:
> > hi, sorry my english
> > I need to copy a data base from windows to linux, how can I save my data
> > base from windows with pg_dump, and where the file is??????
> > and after how can I create the data base in linux without graphic enviroment
> > , just text mode, with commands
>
> yes, pg_dump is just the tool for it.
>
> when you run pg_dump., you decide where the file is going to be
> stored, by redirecting output to a file:
>
> pg_dump database > C:\tmp\foo.sql
>
take a look at:
a) the --clean option and also
b) pg_dumpall
depending on what exactly you have in hands these options would be
helpfull.
Joao
>
> --
> GJ
>