I am using postgresl 7.2.3. Yesterday i have dumped a database using pg_dump
everthing was fine, but the dump was in the wrong order. There were indexes
and views createded before the corresponding table was created.
Its not a big deal but editing 250MB asciifiles isnt actually fun :)
i used "pg_dump dbname > dbname.sql" to dump and "pgsql dbname < dbname.sql"
to restore the database.
Did i missed something?
Are files dumped with pg_dump supposed to be restored with pg_restore or is
it a bug?
In response to
pgsql-novice by date
|Next:||From: Jim Beckstrom||Date: 2003-10-29 13:50:50|
|Subject: foxpro to postgresql 7.x|
|Previous:||From: Godshall Michael||Date: 2003-10-29 04:29:51|
|Subject: Re: Postgres and Crystal Reports|