'Following' the Primary key

On Thu, 2002-03-14 at 13:00, Turbo Fredriksson wrote:

With '\d table' I get the columns, types and modifiers. Also
the Primary key, Indexes etc are shown.

But if I want to know WHAT the primary key 'is pointing to',
how would I do that (ie, what is the primary key)?

Just do \d again on the key index name:

bray=# \d org_contact
Table "org_contact"
Column | Type | Modifiers
---------+-----------------------+-----------
org | character varying(10) | not null
contact | character varying(10) | not null
role | text | not null
address | integer |
Primary key: org_contact_pkey
Triggers: RI_ConstraintTrigger_6933120,
RI_ConstraintTrigger_6933114,
RI_ConstraintTrigger_6933108

bray=# \d org_contact_pkey
Index "org_contact_pkey"
Column | Type
---------+-----------------------
org | character varying(10)
contact | character varying(10)
unique btree (primary key)

--
Oliver Elphick Oliver.Elphick@lfix.co.uk
Isle of Wight http://www.lfix.co.uk/oliver
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C

"Let your light so shine before men, that they may see
your good works, and glorify your Father which is in
heaven." Matthew 5:16

"Oliver" == Oliver Elphick <olly@lfix.co.uk> writes:

Oliver> On Thu, 2002-03-14 at 13:00, Turbo Fredriksson wrote:

With '\d table' I get the columns, types and modifiers. Also
the Primary key, Indexes etc are shown.

But if I want to know WHAT the primary key 'is pointing to',
how would I do that (ie, what is the primary key)?

Oliver> Just do \d again on the key index name:

Oliver> bray=# \d org_contact
Oliver> bray=# \d org_contact_pkey

Cool. Works fine in 7.2, but not 7.1.3 (which we're running on our
production systems)...

Any idea how to do this on 7.1.3?
--
jihad iodine subway arrangements 767 Cocaine 747 Waco, Texas [Hello to
all my fans in domestic surveillance] terrorist security radar North
Korea plutonium Semtex
[See http://www.aclu.org/echelonwatch/index.html for more about this]

Cool. Works fine in 7.2, but not 7.1.3 (which we're running on our
production systems)...
Any idea how to do this on 7.1.3?

contact=# \d t_operation
                                   Table "t_operation"
 Attribute |          Type          |                      Modifier                      
-----------+------------------------+----------------------------------------------------
 op_id     | integer                | not null default nextval('operation_id_seq'::text)
 op_date   | date                   | not null
 op_dpt    | character varying(50)  | 
 op_typ    | character varying(50)  | 
 op_dsc    | character varying(500) | 
 cnx_id    | integer                | not null
Index: t_operation_pkey
                  ^^^^^
                  Default primary key index

contact=# \d t_operation_pkey
Index "t_operation_pkey"
Attribute | Type
-----------+---------
op_id | integer
unique btree (primary key)
^^^^^^ ^^^^^^^^^^^^^

Watch for unique indices created with CREATE UNIQUE INDEX ...

Cheers,

--
Jean-Paul ARGUDO

Quoting Oliver Elphick <olly@lfix.co.uk>:

On Thu, 2002-03-14 at 13:28, Turbo Fredriksson wrote:

Oliver> Just do \d again on the key index name:

Oliver> bray=# \d org_contact
Oliver> bray=# \d org_contact_pkey

Cool. Works fine in 7.2, but not 7.1.3 (which we're running on our
production systems)...

Any idea how to do this on 7.1.3?

psql -E tells me that the queries include this:

I thought it was '-e', and that didn't give any output,
so I never figured out this my self...

SELECT a.attname, format_type(a.atttypid, a.atttypmod),
a.attnotnull, a.atthasdef, a.attnum
FROM pg_class c, pg_attribute a
WHERE c.relname = 'org_contact_pkey'
AND a.attnum > 0 AND a.attrelid = c.oid
ORDER BY a.attnum;

Works like a charm, thanx!!
--
$400 million in gold bullion Soviet Saddam Hussein supercomputer Waco,
Texas Iran munitions PLO explosion Cuba congress Semtex BATF Treasury
NSA
[See http://www.aclu.org/echelonwatch/index.html for more about this]

Turbo Fredriksson wrote:

"Oliver" == Oliver Elphick <olly@lfix.co.uk> writes:

Oliver> On Thu, 2002-03-14 at 13:00, Turbo Fredriksson wrote:

With '\d table' I get the columns, types and modifiers. Also
the Primary key, Indexes etc are shown.

But if I want to know WHAT the primary key 'is pointing to',
how would I do that (ie, what is the primary key)?

Oliver> Just do \d again on the key index name:

Oliver> bray=# \d org_contact
Oliver> bray=# \d org_contact_pkey

Cool. Works fine in 7.2, but not 7.1.3 (which we're running on our
production systems)...

Any idea how to do this on 7.1.3?

See:
http://www.brasileiro.net/postgres/cookbook/view-one-recipe.adp?recipe_id=36

for one possible way.

Joe