Actually, what works is
set search_path='crabdata', 'public' ;
On 2/23/12 1:10 PM, "Adrian Klaver" <adrian(dot)klaver(at)gmail(dot)com> wrote:
> On 02/23/2012 01:08 PM, Willem Buitendyk wrote:
>> I have it set in postgresql.conf and I've also used:
>> alter user postgres set search_path = crabdata,public;
>>
>
> Well search_path is a string, so have you tried?;
> search_path='crabdata,public'
>