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: 478D4879.5070301@iprimus.com.au (view raw or flat)
Thread:
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.

Peter.


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-2014 The PostgreSQL Global Development Group