Re: [GENERAL] sql syntax to replace desc

2009-01-30 Thread Martin Gainty
ial nature and Sender does not endorse distribution to any party other than intended recipient. Sender does not necessarily endorse content contained within this transmission. Date: Sat, 31 Jan 2009 09:20:27 +0700 Subject: [GENERAL] sql syntax to replace desc From: penguinr...@gmail.com To: pgsql-ge

Re: [GENERAL] sql syntax to replace desc

2009-01-30 Thread Richard Broersma
On Fri, Jan 30, 2009 at 6:20 PM, hendra kusuma wrote: > 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 Here is a way to see what \d is doing: rich...@dell-desktop:~$ psql -E -U richard richard=> \d animals **

[GENERAL] sql syntax to replace desc

2009-01-30 Thread hendra kusuma
Dear all, 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 tha