267
267
" c.relfilenode, c.reltablespace, t.spclocation "
268
268
"FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n "
269
269
" ON c.relnamespace = n.oid "
270
272
" LEFT OUTER JOIN pg_catalog.pg_tablespace t "
271
273
" ON c.reltablespace = t.oid "
272
274
"WHERE relkind IN ('r','t', 'i'%s) AND "
273
279
/* exclude possible orphaned temp tables */
274
280
" ((n.nspname !~ '^pg_temp_' AND "
275
281
" n.nspname !~ '^pg_toast_temp_' AND "