Re: [GENERAL] \d command Rodney McDuff Mon, 27 Sep 1999 15:44:12 -0700 HI Mark > I want to be able to build up information about the different tables held > in a database for a small diagnostic tool that I'm writing. > > I need to see the name of each column in the table, the column data type > and size, and if nulls are allowed - essentially what is produced by the > '\d <tablename>' command. > > Does anyone know the SQL query to use on the system tables to produce that > result? I've started to go through them now, and was expecting to find > something along the lines of 'pg_columns', but no such luck. :( >From man psql: -E Echo the actual query generated by \d and other backslash commands -- +-----------------+------------------------------------------+ | _ ^ _ | Dr. Rodney McDuff | | |\ /|\ /| | Network Development, ITS | | \ | / | The University of Queensland | | \ | / | St. Lucia, Brisbane | | \|/ | Queensland, Australia. 4072. | |<-------+------->| TELEPHONE: +61 7 3365 8220 | | /|\ | FACSIMILE: +61 7 3365 4477 | | / | \ | EMAIL: [EMAIL PROTECTED] | | / | \ | | | |/ \|/ \| | Ex ignorantia ad sapientiam | | - v - | Ex luce ad tenebras | +-----------------+------------------------------------------+ ************ Previous message View by thread View by date Next message Reply via email to Search the site The Mail Archive home pgsql-general - all messages pgsql-general - about the list Expand Previous message Next message The Mail Archive home Add your mailing list FAQ Support Privacy 199909272327.JAA02346@its.uq.edu.au

[Rodney McDuff]

HI Mark
> I want to be able to build up information about the different tables held
> in a database for a small diagnostic tool that I'm writing.
> 
> I need to see the name of each column in the table, the column data type
> and size, and if nulls are allowed - essentially what is produced by the
> '\d <tablename>' command.
> 
> Does anyone know the SQL query to use on the system tables to produce that
> result? I've started to go through them now, and was expecting to find
> something along the lines of 'pg_columns', but no such luck. :(

>From man psql:

  -E   Echo the actual query generated by \d and other backslash commands

-- 

  +-----------------+------------------------------------------+
  |    _   ^   _    | Dr. Rodney McDuff                        |
  |   |\  /|\  /|   | Network Development, ITS                 |
  |     \  |  /     | The University of Queensland             |
  |      \ | /      | St. Lucia, Brisbane                      |
  |       \|/       | Queensland, Australia. 4072.             |
  |<-------+------->| TELEPHONE: +61 7 3365 8220               |
  |       /|\       | FACSIMILE: +61 7 3365 4477               |
  |      / | \      | EMAIL: [EMAIL PROTECTED]              |
  |     /  |  \     |                                          |
  |   |/  \|/  \|   |        Ex ignorantia ad sapientiam       |
  |    -   v   -    |            Ex luce ad tenebras           |
  +-----------------+------------------------------------------+



************