Re: [GENERAL] .dmp files in postgresql

2011-11-25 Thread Adrian Klaver
On Friday, November 25, 2011 12:04:38 pm Alpha Beta wrote: > Hi list, > > I have got two files (template1.dmp, example1.dmp) and I want to open them > in postgresql, I tried the following commands: > > - Import *template1 *: > * createdb -U postgres template1 > * psql -U postgres template

Re: [GENERAL] .dmp files in postgresql

2011-11-25 Thread Thom Brown
On 25 November 2011 20:31, Alpha Beta wrote: > While you say, I opened the file with bloc note and I noticed that it's not > a binary file but plain with SQL commands and so on. > I tried what you said also but didn't work. > Any suggestion? or maybe the commands I'm using doesn't find the path fo

Re: [GENERAL] .dmp files in postgresql

2011-11-25 Thread Alpha Beta
While you say, I opened the file with bloc note and I noticed that it's not a binary file but plain with SQL commands and so on. I tried what you said also but didn't work. Any suggestion? or maybe the commands I'm using doesn't find the path for the 2 files? 2011/11/25 Thom Brown > On 25 Novemb

Re: [GENERAL] .dmp files in postgresql

2011-11-25 Thread Thom Brown
On 25 November 2011 20:04, Alpha Beta wrote: > Hi list, > I have got two files (template1.dmp, example1.dmp) and I want to open them > in postgresql, I tried the following commands: > - Import template1 : >     * createdb -U postgres template1 >     * psql -U postgres template1 < template1.dmp > -

[GENERAL] .dmp files in postgresql

2011-11-25 Thread Alpha Beta
Hi list, I have got two files (template1.dmp, example1.dmp) and I want to open them in postgresql, I tried the following commands: - Import *template1 *: * createdb -U postgres template1 * psql -U postgres template1 < template1.dmp - Create the sample of the database: * createdb -U p