Re: what is the equivalent of oracle's DESCRIBE table?
От | Adam Lang |
---|---|
Тема | Re: what is the equivalent of oracle's DESCRIBE table? |
Дата | |
Msg-id | 00d101c01f21$0423a2c0$330a0a0a@Adam обсуждение исходный текст |
Ответ на | RE: what is the equivalent of oracle's DESCRIBE table? ("chris markiewicz" <cmarkiew@commnav.com>) |
Список | pgsql-general |
How about \d <table name> I think that is the type of info oracle spits out for describe (sorry... been 6 months since I touched oracle and it was for only about 4 months that I did. :) ) Adam Lang Systems Engineer Rutgers Casualty Insurance Company ----- Original Message ----- From: "chris markiewicz" <cmarkiew@commnav.com> To: "'Len Morgan'" <len-morgan@crcom.net> Cc: "'PostgreSQL General' (E-mail)" <pgsql-general@postgresql.org> Sent: Friday, September 15, 2000 10:07 AM Subject: RE: [GENERAL] what is the equivalent of oracle's DESCRIBE table? > \dt <table name> only seems to list Owner, Relation, and Type. > > i am looking for something that returns the same info that is found in a > CREATE TABLE statement...column names, data types, etc. i haven't seen > anything like this in the documentation... > > thanks > chris > > -----Original Message----- > From: Len Morgan [mailto:len-morgan@crcom.net] > Sent: Friday, September 15, 2000 9:48 AM > To: cmarkiew@commnav.com > Subject: Re: [GENERAL] what is the equivalent of oracle's DESCRIBE > table? > > > in psql: \dt <table name> > > -----Original Message----- > From: chris markiewicz <cmarkiew@commnav.com> > To: 'PostgreSQL General' <pgsql-general@postgresql.org> > Date: Friday, September 15, 2000 8:51 AM > Subject: [GENERAL] what is the equivalent of oracle's DESCRIBE table? > > > >hello. > > > >what is the postgres equivalent of oracle's command-line DESCRIBE <table> > >command? does there exist a sql92 command for this? > > > >thank you > >chris > > > >
В списке pgsql-general по дате отправления: