>Well, that's what I'd expect to see --- but the prompt indicates that you
>did this in the "postgres" database, which is not where you're having the
>problem. We need to look at the public schema within the mypcc database.
Oops. Here's the mypcc database.
psql mypcc mypcc
mypcc=> select * from pg_namespace where nspname = 'public';
nspname | nspowner | nspacl
---------+----------+------------------------
public | 10 | {postgres=UC/postgres}
(1 row)
mypcc=> \dt
No relations found.
Hmm. However,
mypcc=> \dt *.* Returns all tables, including
public | uiddate | table | postgres
psql mypcc postgres
mypcc=# select * from uiddate where dateonline >= '2014-06-11';
uid | dateonline | uiddateonline | server
-----+------------+---------------+--------
(0 rows)
So it works for the postgres user. I changed the uiddate table owner to the user 'mypcc' expecting the query to work, and it didn't.
psql mypcc mypcc
mypcc=> select * from uiddate where dateonline >= '2014-01-01';
ERROR: relation "uiddate" does not exist
