Обсуждение: Equate for "describe table" ?
Hi, postgres newbie here. What is the equivalent of "desc" or "describe tablename" in postgres? Thanks, John
--howdy:
--i'm assuming you're just getting the table description
via the command line?
database=> \d tablename
Table "tablename"
Attribute | Type | Modifier
-----------+-------------------+----------
username | character varying |
fullname | character varying |
password | character varying |
class | character(1) |
function | character varying |
email | character varying |
options | character varying |
--HTH
-X
-----Original Message-----
From: john [mailto:servobit@m.r.c]
Sent: Monday, November 05, 2001 12:28 PM
To: pgsql-general@postgresql.org
Subject: [GENERAL] Equate for "describe table" ?
Hi,
postgres newbie here.
What is the equivalent of "desc" or "describe tablename" in postgres?
Thanks,
John
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?