Re: Tables view? - Mailing list pgsql-novice

From Tom Lane
Subject Re: Tables view?
Date
Msg-id 20578.1123475131@sss.pgh.pa.us
Whole thread Raw
In response to Tables view?  ("Walker, Jed S" <IMCEAEX-_O=COMCAST_OU=WEST+20DIVISION_CN=RECIPIENTS_CN=JWALKE1078E@cable.comcast.com>)
List pgsql-novice
"Walker, Jed S" <IMCEAEX-_O=COMCAST_OU=WEST+20DIVISION_CN=RECIPIENTS_CN=JWALKE1078E@cable.comcast.com> writes:
> I have a need to select out all tables that are not temporary.

Basically, you ignore the ones that are in schemas named "pg_temp_NNN".

            regards, tom lane

pgsql-novice by date:

Previous
From: "Walker, Jed S"
Date:
Subject: Tables view?
Next
From: babu
Date:
Subject: postgresql with ssl on windows