Tools

How to generate a WHD Tables and Schema list in the PostgreSQL database

This article describes how to generate a WHD Tables and Schema list from a Web Help Desk deployment connected to a PostgreSQL database.

First published date

11/29/2018 11:00 PM

Last published date

11/29/2018 11:00 PM

Overview

This article describes how to generate a WHD Tables and Schema list in the PostgreSQL database.

Product section

Web Help Desk

Resolution

  • Log in to WebHelpDesk server.
  • Navigate to directory: <WebHelpDesk>\pgsql9\bin.
  • Look for the file pgAdmin3 and run it as "administrator".
  • On pgAdmin3 window, go to File > Add Server.
  • Add the following:
                - Name: WHDDB
                - Host: localhost
                - Port: 20293
                - Maintenance DB: postgres
                - Username: whd
                - Password: whd
  • Click Ok and Ok again on the "Guru Hint" window.
  • Expand "Databases".
  • Select your WHD database(e.g. whd).
  • Run the following SELECT SQL statements:
-- Scripts are not supported under any SolarWinds support program or service.
-- Scripts are provided AS IS without warranty of any kind. SolarWinds further
-- disclaims all warranties including, without limitation, any implied warranties
-- of merchantability or of fitness for a particular purpose. The risk arising
-- out of the use or performance of the scripts and documentation stays with you.
-- In no event shall SolarWinds or anyone else involved in the creation,
-- production, or delivery of the scripts be liable for any damages whatsoever
-- (including, without limitation, damages for loss of business profits, business
-- interruption, loss of business information, or other pecuniary loss) arising
-- out of the use of or inability to use the scripts or documentation.

SELECT * FROM information_schema.tables
SELECT * FROM information_schema.columns
SELECT * FROM information_schema.tables WHERE table_schema = 'public'