Postgresql constraint changes

Question

I added a constraint to a Postgres table, but when I do "\d tablename" the constraint doesn't show up.

How do I see what the constraints are? I'm sure this is a very basic thing, but I can't find the answer!

EDIT: the constraint does actually exist and work.

EDIT: first response now shows how constraint can be found using information_schema, but this method is not very useful as tablename/column name the constraint relates to is not shown. any ideas how to enable constraint output using \d command?

EDIT: problem seems to have fixed itself after a restart of psql and wasting 2 hours of my life. grrr

Answer 1

Normally it does show up in \d output. Potential problems I may think of is either old version of postgresql or version mismatch between psql and server. If you want to figure out your constraints by hand, you may want to look into information_schema namespace pg_constraint system table.

Answer 2

OK. I figured out what happened and post to save somebody else from wasting their time: I must have entered the command "\t" at some stage to change formatting to show only tuples. Where's the bashing head against brick wall emoticon when you need it!