On Thu, Nov 25, 2004 at 10:47:33AM +0000, Chris Green wrote:
> On Thu, Nov 25, 2004 at 04:08:30PM +0530, Nageshwar Rao wrote:
> > I have created a table and would like to display the structure to find
> > out datatype and length.
> >
> > Just like in Oracle describe table_name;
>
> in psql:-
>
> \dt
>
That's "\dt <tablename>" of course.
> Basically the \d commands in psql give you much of what DESCRIBE does
> for Oracle and mysql. \? to see all the \ commands.
>
--
Chris Green ([EMAIL PROTECTED])
"Never ascribe to malice, that which can be explained by incompetence."
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
