Обсуждение: 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
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