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.