documentation.HELP! pgAdmin III Documentation

Object search

pgAdmin III

previous page next page

Navigation

  • index
  • next |
  • previous |
  • pgAdmin3 LTS 1.23.0a documentation »
  • Using pgAdmin III »
  • pgAdmin Main Window »

Object search

_images/search.png

With this dialog, you can search for almost any kind of objects in a database.

You can access it by right clicking a database and select “Search objects” or by hitting CTRL-G.

The minimum pattern length are 3 characters except for operators. The search performed is non-case sensitive and will find all objets whose name contains the pattern. You can only search for object names.

The result is presented in the grid with object type, object name and the object tree path. You can click on a result row to select the object in the browser. If the object is grey, this means that you don’t have enabled those object types in the Browser settings, so you can’t click on it.

Navigation

  • index
  • next |
  • previous |
  • pgAdmin3 LTS 1.23.0a documentation »
  • Using pgAdmin III »
  • pgAdmin Main Window »
© Copyright 2002 - 2016, The pgAdmin Development Team. Created using Sphinx 1.4.8.
previous page start next page

Menu

  • Homepage

Table of contents

  • pgAdmin3 LTS 1.23.0a documentation
  • Introduction
  • Using pgAdmin III
    • pgAdmin Main Window
      • Getting started
        • Object search
    • Connect to server
      • Connection errors
        • could not connect to Server: Connection refused
        • FATAL: no pg_hba.conf entry
    • Change Password
      • Good practice
    • Control Server
    • Query tool
      • Graphical Query builder
      • pgAdmin Data Export
      • Query Tool Macros
      • pgScript Scripting Language Reference
        • Overview
        • Examples
          • Batch table creations
          • Insert random data
          • Batch table deletions
          • Print information on screen
        • SQL Commands
        • Variables
          • Simple variables
            • Simple variable declaration
            • Simple variable affectation
            • Data generators
          • Records
            • Record declaration
            • Record affectation
            • SQL queries
            • Record functions
          • Cast
          • Operations
            • Strings
            • Numbers
            • Records
        • Control-of-flow structures
          • Conditional structure
          • Loop structure
          • Conditions
        • Additional functions and procedures
          • Procedures
            • Print
            • Assert
            • Remove line
          • Functions
            • Trim
            • Lines
            • Columns
        • Random data generators
          • Overview of the generators
          • Sequence and seeding
          • Data generators
            • Integer numbers
            • Real numbers
            • Dates
            • Times
            • Timestamps (date/times)
            • Strings
            • Strings from regular expressions
            • Strings from dictionary files
            • Reference to another field
    • pgAdmin Debugger
    • pgAdmin Data Export
    • Edit Data
      • View Data Options
    • Maintain a database object
      • VACUUM
      • ANALYZE
      • REINDEX
    • Backup
    • Supported File Formats
    • The Backup Dialog
    • Restore
    • The Restore Dialog
    • Grant Wizard
    • Report Tool
      • Default XSL Stylesheet
        • Sample XML Data
    • Database Server Status
    • pgAdmin Options
      • pgAdmin Browser Options
      • pgAdmin Query tool Options
      • pgAdmin Database Designer Options
      • pgAdmin Server Status Options
      • pgAdmin Miscellaneous Options
    • Guru Hints
    • Command Line Parameters
  • pgAgent
    • pgAgent Installation
      • Database setup
      • Daemon installation on Unix
      • Service installation on Windows
      • Security concerns
    • pgAgent Jobs
    • pgAgent Schedules
    • pgAgent Steps
  • Slony-I support
    • Slony-I with pgAdmin III overview
    • Slony-I administration with pgAdmin III: installation
      • Prerequisites
      • Overview
      • Create cluster and first node
      • Join additional nodes to cluster
      • Upgrade node to new cluster software
    • Creating paths and listens
      • Create paths to other nodes
      • Create listens to other nodes
    • Creating sets and subscriptions
      • Create replication set
      • Define replicated table
      • Define replicated sequence
      • Subscribe a replication set
    • Execute DDL scripts with Slony-I
    • Slony-I tasks
    • Slony-I example
  • Extended features
  • Appendices
    • Bug Reporting
    • The pgAdmin Development Team
    • Translation team
    • The PostgreSQL Licence
    • The MIT Kerberos Licence
      • Kerberos Copyright
    • The OpenSSL Licence

Get in touch

Submit feedback about this site to:

  • [email protected]

© documentation.help. Design: rehmann.co.