pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  

help / color / mirror / Atom feed

unlooged tables
3+ messages / 2 participants
[nested] [flat]

* unlooged tables
@ 2012-11-06 21:09  Igor Neyman <ineyman@perceptron.com>
  0 siblings, 1 reply; 3+ messages in thread

From: Igor Neyman @ 2012-11-06 21:09 UTC (permalink / raw)
  To: pgsql-admin

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.

Regards,
Igor Neyman

^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: unlooged tables
@ 2012-11-06 21:20  Igor Neyman <ineyman@perceptron.com>
  0 siblings, 0 replies; 3+ messages in thread

From: Igor Neyman @ 2012-11-06 21:20 UTC (permalink / raw)
  To: pgsql-admin

From: Igor Neyman 
Sent: Tuesday, November 06, 2012 4:09 PM
To: pgsql-admin@postgresql.org
Subject: unlooged tables

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.

Regards,
Igor Neyman

Sorry for the noise.
As soon as previous message was sent I found it:

relpersistence column in pg_class ("u" for unlogged tables, "p" - for "normal" tables)

Igor N.




^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: unlooged tables
@ 2012-11-07 01:41  Craig Ringer <ringerc@ringerc.id.au>
  parent: Igor Neyman <ineyman@perceptron.com>
  0 siblings, 0 replies; 3+ messages in thread

From: Craig Ringer @ 2012-11-07 01:41 UTC (permalink / raw)
  To: Igor Neyman <ineyman@perceptron.com>; +Cc: 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

^ permalink  raw  reply  [nested|flat] 3+ messages in thread

end of thread, other threads:[~2012-11-07 01:41 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2012-11-06 21:09 unlooged tables Igor Neyman <ineyman@perceptron.com>
2012-11-07 01:41 ` Craig Ringer <ringerc@ringerc.id.au>
2012-11-06 21:20 Re: unlooged tables Igor Neyman <ineyman@perceptron.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox