Tags: cms, database, empty, implementede, ininformation_schema, key_column_usage, mysql, oracle, postgresql, referential_constraints, schema, select, sql

information schema

On Database » PostgreSQL

1,544 words with 1 Comments; publish: Sun, 25 May 2008 00:10:00 GMT; (250141.11, « »)

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/

--(end of broadcast)--

TIP 9: the planner will ignore your desire to choose an index scan if your

joining column's datatypes do not match

All Comments

Leave a comment...

  • 1 Comments
    • Wei Shi <weishisky.postgresql.todaysummary.com.yahoo.com> writes:

      > Does anybody know why "key_column_usage", and

      > "referential_constraints" are empty in

      > information_schema?

      They work for me ...

      regards, tom lane

      --(end of broadcast)--

      TIP 2: you can get off all lists at once with the unregister command

      (send "unregister YourEmailAddressHere" to majordomo.postgresql.todaysummary.com.postgresql.org)

      #1; Sun, 25 May 2008 00:11:00 GMT