From: Arihan Sinha <arihan_sinha@...>
Date: 2010-09-27T18:45:10+09:00
Subject: Re: Unable to retrieve data from tble

Brian Candler wrote:
> Arihan Sinha wrote:
>>     res  = conn.exec('SELECT Email FROM
>> UserMaster.Schemas.public.Tables.MasterUser WHERE
>> UserName=\'arihan123\';')
> ...
>> `query': ERROR C42601 Mimproper qualified name (too many dotted names):
>> usermaster.schemas.public.tables.masteruser P19 Fgram.y L9933
>> Rbase_yyparse (RuntimeError)
> 
> This isn't a ruby question, it's a postgres one.
> 
> Make a query which works using the pg command line tool, then use it in 
> Ruby.

Thanks . I've done that.

It would be

  res  = conn.exec('SELECT "Email" FROM "MasterUser" WHERE 
"UserName"=\'arihan123\';')
-- 
Posted via http://www.ruby-forum.com/.