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

information schema

From: Wei Shi <weishisky(at)yahoo(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: information schema
Date: 2004-05-30 04:52:36
Message-ID: 20040530045236.68024.qmail@web60306.mail.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-general
Does anybody know why "key_column_usage", and
"referential_constraints" are empty in
information_schema?  Have these been implemented?

e.g.
cms=# select * from
information_schema.key_column_usage;
 constraint_catalog | constraint_schema |
constraint_name | table_catalog | table_schema |
table_name | column_name | ordinal_position
--------------------+-------------------+-----------------+---------------+--------------+------------+-------------+------------------
(0 rows)

cms=# select * from
information_schema.referential_constraints;
 constraint_catalog | constraint_schema |
constraint_name | unique_constraint_catalog |
unique_constraint_schema | unique_constraint_name |
match_option | update_rule | delete_rule
--------------------+-------------------+-----------------+---------------------------+--------------------------+------------------------+--------------+-------------+-------------
(0 rows)

Thanks.

Wei


	
		
__________________________________
Do you Yahoo!?
Friends.  Fun.  Try the all-new Yahoo! Messenger.
http://messenger.yahoo.com/ 

Responses

pgsql-general by date

Next:From: Jurgen DefurneDate: 2004-05-30 08:59:05
Subject: Trying to mail from my virtual network
Previous:From: Tom LaneDate: 2004-05-30 03:58:27
Subject: Re: ERROR: invalid page header in block 67 of relation "pg_proc"

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