| From: | Craig Ringer <ringerc(at)ringerc(dot)id(dot)au> |
|---|---|
| To: | Igor Neyman <ineyman(at)perceptron(dot)com> |
| Cc: | "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: unlooged tables |
| Date: | 2012-11-07 01:41:28 |
| Message-ID: | 5099BC48.6090202@ringerc.id.au |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
On 11/07/2012 05:09 AM, Igor Neyman wrote:
>
> Hi,
>
>
>
> Where in pg_catalog I can find, if the table was created as "unlogged"
> (or not)?
>
> As in: create unlogged table t1(c1 int);
>
> I can't seem to find this info in pg_catalog tables/views.
>
>
>
> Tried psql with --E to describe (\d) unlogged table, but it was not
> helpful.
>
SELECT relpersistence FROM pg_class WHERE relname = 't1';
'u' is unlogged, 'p' is persistent, 't' is temporary.
See http://www.postgresql.org/docs/current/static/catalog-pg-class.html
<http://www.postgresql.org/docs/9.2/static/catalog-pg-class.html>
--
Craig Ringer
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2012-11-07 18:42:32 | Re: pg_upgrade from 9.1 to 9.2 takes a really long time (compared to previous versions)? |
| Previous Message | Scott Ribe | 2012-11-07 00:18:56 | Re: MySQL Blackhole Engine |