Question

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 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.

-- 
  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.
_______________________________

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 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 ?

The trick is to start psql with the "-E" option.

-- BMT

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 ===

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 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.

--
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