[NOVCE] Describe Table Problems

From: "Ridvan Lakas ng Bayan S(dot) Baluyos" <ridvan(at)baluyos(dot)net>
To: pgsql-novice(at)postgresql(dot)org
Subject: [NOVCE] Describe Table Problems
Date: 2009-08-04 02:18:44
Message-ID: 7f4f9efa0908031918j9d09521ybf7702bfbcabc3e0@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(dot)baluyos(at)qualservcentral(dot)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.

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2009-08-04 03:38:59 Re: [NOVCE] Describe Table Problems
Previous Message Greg Stark 2009-08-04 00:09:12 Re: Index size