Re: did not find any relation for existing table

>
>Please check the output of the below query.
>
>select tablename,schemaname from pg_tables where schemaname='history';
>
>I assume that the table might have created under public schema. Please
>check
>the output of the above query and if the output consists of public in place
>of schemaname column then the object is residing in public schema not in
>history schema.
>


cdx_post-# select tablename,schemaname from pg_tables where
schemaname='history';
          tablename           | schemaname
------------------------------+------------
client                       | history

Thanks for the suggestion though (-:

_________________________________________________________________
Share folders without harming wildlife!
http://www.communicationevolved.com/en-ie/