Postgres Pro
Downloads
Home   >   mailing lists

Is a table temporary - Mailing list pgsql-novice

From Walker, Jed S
Subject Is a table temporary
Date
Msg-id F7638DABBEBB4A4CB70616DE2B19E6B825F706@COENGEXCMB01.cable.comcast.com
Whole thread Raw
Responses Re: Is a table temporary  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-novice
Tree view

Is there a way to determine if a table is temporary. Currently I have a cursor that goes through pg_class for all tables and views owned by a particular owner, but I need to exclude temporary tables. How can I do this?

Thanks,

Jed

pgsql-novice by date:

Previous
From: "Morgan Kita"
Date:
Subject: problem with pg_dump and subsequent restoration.
Next
From: Tom Lane
Date:
Subject: Re: problem with pg_dump and subsequent restoration.