I have a need to select out all tables that are not temporary. Currently
I'm pulling this from pg_class but I can't find a way to identify
temporary tables. I found the "tables" view listed in the documentation
but when I do "select * from tables" as the user that owns the tables
I'm interested in, I get "relation "tables" does not exist". I also get
this when logged in as postgres.
What do I need to do to see this table, or select only permanent tables
from pg_class?
Thanks,
Jed.