Re: msaccess to postgre

Obe, Regina wrote:
> Peter,
>
> 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
> qualification.
>
> 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.

Peter.