Skip site navigation (1) Skip section navigation (2)

psql: \d+ shows OID-ness

From: Neil Conway <neilc(at)samurai(dot)com>
To: pgsql-patches(at)postgresql(dot)org
Subject: psql: \d+ shows OID-ness
Date: 2004-04-22 06:44:21
Message-ID: 1082616261.7010.53.camel@tokyo (view raw, whole thread or download thread mbox)
Lists: pgsql-patches
This patch makes psql's \d+ command indicate whether the table in
question contains OIDs or not. I didn't add this information to \d, on
the grounds that \d is more commonly used and few people will care
whether the table as OIDs. Example output:

nconway=# create table t1 () with oids;
nconway=# create table t2 () without oids;
nconway=# \d+ t1
            Table "public.t1"
 Column | Type | Modifiers | Description
Contains OIDs: yes

nconway=# \d+ t2
            Table "public.t2"
 Column | Type | Modifiers | Description
Contains OIDs: no

I also fixed a bunch of markup in the psql reference manual (which takes
up about 90% of the patch itself).

Barring any objections I'll apply this patch within 24 hours.


Attachment: psql-show-oids-2.patch
Description: text/x-patch (24.8 KB)


pgsql-patches by date

Next:From: Neil ConwayDate: 2004-04-22 07:24:01
Subject: Re: make 'PrivateRefCount' 32 bits wide
Previous:From: Peter EisentrautDate: 2004-04-22 05:15:02
Subject: Re: PSQLRC environment variable.

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group