[NOVCE] Describe Table Problems - Mailing list pgsql-novice

From Ridvan Lakas ng Bayan S. Baluyos
Subject [NOVCE] Describe Table Problems
Date
Msg-id 7f4f9efa0908031918j9d09521ybf7702bfbcabc3e0@mail.gmail.com
Whole thread Raw
Responses Re: [NOVCE] Describe Table Problems  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-novice
Hi list,

I'm currently having problems trying to describe a table in one of my database servers. Here's the error:

backoffice_t2=# \d control.storedate_done
ERROR:  column t.tgconstraint does not exist
LINE 3: WHERE t.tgrelid = '1154864' AND t.tgconstraint = 0
                                        ^
backoffice_t2=#


Even in phpPgAdmin, I could not check the description of the table. Is there another way for me to check the table? I just want to see what triggers are created in a specific table.


TIA,

Ridvan



--
リヅバン バルヨス
ridvan.baluyos@qualservcentral.com
http://ridvan.baluyos.net
http://www.onxiam.com/people/rbaluyos

Registered Linux User #439466
Registered Ubuntu User #16034
Q: Have you heard of the Object-Oriented way to get wealthy?
A: Inheritance.

pgsql-novice by date:

Previous
From: Greg Stark
Date:
Subject: Re: Index size
Next
From: Tom Lane
Date:
Subject: Re: [NOVCE] Describe Table Problems