Peter Eisentraut wrote:
>You don't need to create any tables, just schemas.
Thanks for the help Peter, i've since resolved the problem.
The production install was in fact, 7.2.3, not 7.3.2 as I stated
earlier, my bad.
It appears that PG only started supporting schemas since 7.3.x.
I was assumming that schema names were stored in a system table
somewhere, which, upon further research, are not. My bad.
Never make assumptions :)
Been messing around with 7.4.1 since (as said i'm due an update). Its
Now to find a JDBC driver that lets me set Auto Commit off without
But that, as they say, is a different story.....
In response to
pgsql-admin by date
|Next:||From: Tom Lane||Date: 2004-01-14 19:22:31|
|Subject: Re: Missing Schema |
|Previous:||From: Rajesh Kumar Mallah||Date: 2004-01-14 18:26:14|
|Subject: Re: Are there programs to graph database schema?|