--- Livia Santos [EMAIL PROTECTED] wrote:
Is there any command that describe a table, such as desc table_name as in
Oracle?
from the psql user interface, you can use the following command:
\dt
to list all table in the currently set schema
\d [table_name]
the see the table attributes
\d+
On 8/20/07, Livia Santos [EMAIL PROTECTED] wrote:
Hi.
Is there any command that describe a table, such as desc table_name as in
Oracle?
Yes and no. The psql client has a series of \ commands that can
describe pretty much anything in the db in a pretty print nature and a
minimum of typing.
Livia Santos wrote:
Hi.
Is there any command that describe a table, such as desc table_name as
in Oracle?
Not sure how desc table_name works in Oracle, but from psql you can use:
\dt table_name
Issue \? in psql for more information.
Regards,
roppert
Thanks in advance.
--
Lívia Silva
Thanks a lot, guys.
\d table_name is exactly what I needed!
On 8/20/07, Robert Gravsjö [EMAIL PROTECTED] wrote:
Livia Santos wrote:
Hi.
Is there any command that describe a table, such as desc table_name as
in Oracle?
Not sure how desc table_name works in Oracle, but from psql you
You could use the COMMENT command.
Something like:
COMMENT ON TABLE table name IS 'comment';
HTH,
Colin
-Original Message-
From: Fariba Noorbakhsh [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, 04 July 2001 14:54
To: [EMAIL PROTECTED]
Subject: [GENERAL] Table Description!!
Hi
PROTECTED];
[EMAIL PROTECTED]
Subject: RE: [GENERAL] Table Description!!
Hi,
I couldn't find such a thing.
May be better if having a copy from pg_tables and add a
description column
to that:
Create table foo as Select * from pg_tables;
Alter table foo add col descript text ;
HTH