Thanks a lot, guys.
\d 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
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 San
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 typin
--- 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+ [
Hi.
Is there any command that describe a table, such as desc table_name as in
Oracle?
Thanks in advance.
--
Lívia Silva Santos
IL PROTECTED]; [EMAIL 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 *
You could use the "COMMENT" command.
Something like:
COMMENT ON TABLE IS '';
HTH,
Colin
> -Original Message-
> From: Fariba Noorbakhsh [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, 04 July 2001 14:54
> To: [EMAIL PROTECTED]
> Subject: [GENERAL] Table
