Skip site navigation (1) Skip section navigation (2)

Re: msaccess to postgre

From: Peter Jackson <tasmaniac(at)iprimus(dot)com(dot)au>
To: pgsql <pgsql-novice(at)postgresql(dot)org>
Subject: Re: msaccess to postgre
Date: 2008-01-15 23:57:45
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
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.


In response to

pgsql-novice by date

Next:From: Tom LaneDate: 2008-01-16 01:04:03
Subject: Re: SQL to extract column metadata
Previous:From: Scott FordDate: 2008-01-15 23:46:38
Subject: SQL to extract column metadata

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group