Have you tried to use "copy" to export the data from each table?
As a last resort you could try this, since you said you can still
select data from the tables.
Make a list of tables then :
sed -e "/^.*/copy & TO '&.sql';/" table.list | psql database
This should create a file for each table ending with ".sql".
Then re-create the table on the new DB and use "copy" to
import the data from the files.
David Suela Fernández wrote:
El mié, 25-08-2004 a las 20:54, Tom Lane escribió:
David Suela =?ISO-8859-1?Q?Fern=E1ndez?= <[EMAIL PROTECTED]> writes:
The problem is that pg_dump always give me the next error:
pg_dump: SQL command failed
pg_dump: Error message from server: ERROR: relation "pg_user" does not exist
Have you tried re-creating that view?
CREATE VIEW pg_catalog.pg_user AS
SELECT
usename,
usesysid,
usecreatedb,
usesuper,
usecatupd,
'********'::text as passwd,
valuntil,
useconfig
FROM pg_shadow;
regards, tom lane
It return:
ERROR: permission denied to create "pg_catalog.pg_user"
DETAIL: System catalog modifications are currently disallowed.
How can i change this permissions?
--
Guy Fraser
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly