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
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
**
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