Thread: Question
Dear PSQL,
I need to make a documentation for my database. The documentation I want is almost exactly like the result of "\d" command. I want to make the report using a database manager application, and it requires me to make my own report by typing the SQL command in it. Can you please provide me the command behind "\d" or perhaps tell me what attributes do you use to build that "\d" report ?
Thank you,
Peter Futaro
I need to make a documentation for my database. The documentation I want is almost exactly like the result of "\d" command. I want to make the report using a database manager application, and it requires me to make my own report by typing the SQL command in it. Can you please provide me the command behind "\d" or perhaps tell me what attributes do you use to build that "\d" report ?
Thank you,
Peter Futaro
Yahoo! Music Unlimited - Access over 1 million songs. Try it free.
Read the FAQ. --------------------------------------------------------------------------- Peter Futaro wrote: > Dear PSQL, > > I need to make a documentation for my database. The documentation I want is almost exactly like the result of "\d" command.I want to make the report using a database manager application, and it requires me to make my own report by typingthe SQL command in it. Can you please provide me the command behind "\d" or perhaps tell me what attributes do youuse to build that "\d" report ? > > Thank you, > Peter Futaro > > > > --------------------------------- > Yahoo! Music Unlimited - Access over 1 million songs. Try it free. -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073
Peter Futaro wrote: > Dear PSQL, > > I need to make a documentation for my database. The documentation I want > is almost exactly like the result of "\d" command. I want to make the > report using a database manager application, and it requires me to make > my own report by typing the SQL command in it. Can you please provide me > the command behind "\d" or perhaps tell me what attributes do you use to > build that "\d" report ? > > Thank you, > Peter Futaro > Start psql with -E to see the internal commands. psql --help for more details -- _______________________________ This e-mail may be privileged and/or confidential, and the sender does not waive any related rights and obligations. Any distribution, use or copying of this e-mail or the information it contains by other than an intended recipient is unauthorized. If you received this e-mail in error, please advise me (by return e-mail or otherwise) immediately. _______________________________
am 29.11.2005, um 1:25:37 -0800 mailte Peter Futaro folgendes: > Can you please provide me the command behind "\d" or perhaps tell > me what attributes do you use to build that "\d" report ? Start psql with -E. Now you can see the sql-commands for \d and other commands like this. HTH, Andreas -- Andreas Kretschmer (Kontakt: siehe Header) Heynitz: 035242/47212, D1: 0160/7141639 GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net === Schollglas Unternehmensgruppe ===
Peter Futaro wrote: > > I need to make a documentation for my database. The documentation I want is almost exactly like the result of "\d" command.I want to make the report using a database manager application, and it requires me to make my own report by typingthe SQL command in it. Can you please provide me the command behind "\d" or perhaps tell me what attributes do youuse to build that "\d" report ? > > The trick is to start psql with the "-E" option. -- BMT
You migth also find http://pgfoundry.org/projects/newsysviews/ useful. On Tue, Nov 29, 2005 at 01:25:37AM -0800, Peter Futaro wrote: > Dear PSQL, > > I need to make a documentation for my database. The documentation I want is almost exactly like the result of "\d" command.I want to make the report using a database manager application, and it requires me to make my own report by typingthe SQL command in it. Can you please provide me the command behind "\d" or perhaps tell me what attributes do youuse to build that "\d" report ? > > Thank you, > Peter Futaro > > > > --------------------------------- > Yahoo! Music Unlimited - Access over 1 million songs. Try it free. -- Jim C. Nasby, Sr. Engineering Consultant jnasby@pervasive.com Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461