Obe, Regina wrote:
> Usually the search paths by default are set as $user, public. Postgres
> puts tables in the first schema in search path (if it exists) and then
> tries the next if the previous does not exist, if no schema
> So to force Access to put tables in a certain schema, one way to do it
> is to create an account with the same name as the schema - e.g. create
> an account called accounts and log in as that and export all your
> accounts tables etc..
> I'm really not quite sure why your approach puts it in the public always
> unless your search path settings were not saved (did you restart/reload
> config of your postgresql server after setting search paths?)
OK grab a really big hammer and hit me. I had forgotten to restart the
postgresql server. I actually thought it might've been one of the
settings you could alter on the fly but obviously I was wrong.
Thanks again and I will now write Restart server 500 times.
In response to
pgsql-novice by date
|Next:||From: Tom Lane||Date: 2008-01-16 01:04:03|
|Subject: Re: SQL to extract column metadata |
|Previous:||From: Scott Ford||Date: 2008-01-15 23:46:38|
|Subject: SQL to extract column metadata|