Hi,
Thanks for your replies.
Peter was spot on.
I was trying to use a reserved word 'public'
'public_plan' works fine.
Kind regards
Rudi Starcevic.
Peter Eisentraut wrote:
>Rudi Starcevic writes:
>
>>I can't see why my sql here is throwing an error,
>>
>
>(Next time it might be nice to show *what* error...)
>
>> SELECT *
>> FROM plan_template
>> WHERE public = true;
>>
>
>"public" is a reserved word. You need to double-quote it to be able to
>use it.
>