Re: Strange "missing tables" problem

hi,

You may try checking:
SELECT * FROM pg_catalog.pg_class WHERE relname = 'customers'
SELECT * FROM pg_catalog.pg_tables WHERE tablename = 'customers'
to what's the status of your table.

Regards,
foo

Denis BUCHER wrote:
> Hello,
>
> Small correction to my previous email :
>
>
>> I have a strange problem since I moved some tables to a schema, some
>> tables are missing from the list (with \d or \dt) but they are still
>> present anyway ???!!!!!
>>
>> Example :
>>
>>> $ psql mybase
>>> Bienvenue dans psql 8.1.17, l'interface interactive de PostgreSQL.
>>> Saisissez:
>>> mybase=#
>>> bw_rma=# \dt
>>> Liste des relations
>>> Schéma | Nom | Type | Propriétaire
>>> -----------------+--------------------------+-------+--------------
>>> import | rebates_products | table | postgres
>>> import | rebates_customers | table | postgres
>>> rma | categories | table | postgres
>>> rma | customers | table | postgres
>>> rma | defauts | table | postgres
>>> rma | providers | table | postgres
>>>
>> No trace of my import.customers table ?????
>>
>> But if I do :
>>
>>> bw_rma=# SELECT count(*) FROM import.customers;
>>> count
>>> -------
>>> 86703
>>> (1 ligne)
>>>
>> My table is there and I can access it !!!
>>
>> Any hint or help would be greatly appreciated !
>>
>> I can do without it, but it's a little strange not to be able to list
>> the objects present in the database...
>>
>
> Denis
>
>
>