I need to see my table structure complete with it's constraint (at least
primary key, foreign key, not null, unique)
In oracle or mysql, I usually use desc table_name to achieve such result
But I find from pgsql-doc that desc isn't implemented.
Does anyone know some sql syntax to do that?
I'm not talking about \d option at psql console since I need that data
to be called from programming language such as PHP and Ruby
pgsql-general by date
|Next:||From: Richard Broersma||Date: 2009-01-31 02:34:40|
|Subject: Re: sql syntax to replace desc|
|Previous:||From: rhubbell||Date: 2009-01-30 23:44:48|
|Subject: Re: Pet Peeves?|