Re: Join Problem - Mailing list pgsql-general

From scott.marlowe
Subject Re: Join Problem
Date
Msg-id Pine.LNX.4.33.0307231431090.23336-100000@css120.ihs.com
Whole thread Raw
In response to Re: Join Problem  ("Rob Sell" <robs@facnd.com>)
List pgsql-general
On Wed, 23 Jul 2003, Rob Sell wrote:

> Ok I was going to send in the schema from both db's and when trying to get
> the schema through phppgadmin it works fine on the old db, but on the new db
> I get this error "PostgreSQL said: ERROR:  Relation "pg_relcheck" does not
> exist"
>
> What is that? And could that be related to my problem?

Nah, likely just a version issue (i.e. the new database doesn't have the
system tables that phppgadmin expects)

you can get a dump of the schema / tables with pg_dump on each box:

pg_dump -s dbname -t tablename <- this will dump the schema


pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: dump_all/restore times?
Next
From: Network Administrator
Date:
Subject: Re: birthday calculation