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
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
