pgweb.clientissimo.com Open in urlscan Pro
194.163.169.79  Public Scan

Form analysis
2 forms found in the DOM

#

<form class="filters" action="#" id="rows_filter">
  <span>Search</span>
  <select class="column form-control"></select>
  <select class="filter form-control">
    <option value="">Select filter</option>
    <option value="equal">=</option>
    <option value="not_equal">≠</option>
    <option value="greater">&gt;</option>
    <option value="greater_eq">≥</option>
    <option value="less">&lt;</option>
    <option value="less_eq">≤</option>
    <option value="like">LIKE</option>
    <option value="ilike">ILIKE</option>
    <option value="null">IS NULL</option>
    <option value="not_null">NOT NULL</option>
  </select>
  <input type="text" class="form-control" placeholder="Filter value" id="table_filter_value">
  <button class="btn btn-primary btn-sm apply-filters" type="submit">Apply</button>
  <button class="btn btn-default btn-sm reset-filters"><i class="fa fa-times"></i></button>
</form>

<form role="form" class="form-horizontal" id="connection_form">
  <div class="text-center">
    <div class="btn-group btn-group-sm connection-group-switch">
      <button type="button" data="scheme" class="btn btn-default" id="connection_scheme">Scheme</button>
      <button type="button" data="standard" class="btn btn-default active" id="connection_standard">Standard</button>
      <button type="button" data="ssh" class="btn btn-default" id="connection_ssh">SSH</button>
    </div>
  </div>
  <hr>
  <div class="connection-scheme-group">
    <div class="form-group">
      <div class="col-sm-12">
        <label>Enter server URL scheme</label>
        <input type="text" class="form-control" id="connection_url" name="url" autocomplete="off">
        <p class="help-block"> URL format: postgres://user:password@host:port/db?sslmode=mode<br> Read more on PostgreSQL
          <a href="https://www.postgresql.org/docs/current/static/libpq-connect.html#LIBPQ-CONNSTRING" target="_blank">connection string format</a>. </p>
      </div>
    </div>
  </div>
  <div class="connection-standard-group">
    <div class="form-group bookmarks">
      <label class="col-sm-3 control-label">Bookmark</label>
      <div class="col-sm-9">
        <select class="form-control" id="connection_bookmarks"></select>
      </div>
    </div>
    <div class="form-group">
      <label class="col-sm-3 control-label">Host</label>
      <div class="col-sm-7">
        <input type="text" id="pg_host" class="form-control">
      </div>
      <div class="col-sm-2 no-left-padding">
        <input type="text" id="pg_port" class="form-control" placeholder="5432">
      </div>
    </div>
    <div class="form-group">
      <label class="col-sm-3 control-label">Username</label>
      <div class="col-sm-9">
        <input type="text" id="pg_user" class="form-control">
      </div>
    </div>
    <div class="form-group">
      <label class="col-sm-3 control-label">Password</label>
      <div class="col-sm-9">
        <input type="password" id="pg_password" class="form-control">
      </div>
    </div>
    <div class="form-group">
      <label class="col-sm-3 control-label">Database</label>
      <div class="col-sm-9">
        <input type="text" id="pg_db" class="form-control">
      </div>
    </div>
    <div class="form-group">
      <label class="col-sm-3 control-label">SSL Mode</label>
      <div class="col-sm-9">
        <select class="form-control" id="connection_ssl">
          <option value="disable">disable</option>
          <option value="require" selected="selected">require</option>
          <option value="verify-full">verify-full</option>
        </select>
      </div>
    </div>
  </div>
  <div class="connection-ssh-group">
    <hr>
    <h3 class="text-center">SSH Connection</h3>
    <div class="form-group">
      <label class="col-sm-3 control-label">Host</label>
      <div class="col-sm-7">
        <input type="text" id="ssh_host" class="form-control">
      </div>
      <div class="col-sm-2 no-left-padding">
        <input type="text" id="ssh_port" class="form-control" placeholder="22">
      </div>
    </div>
    <div class="form-group">
      <label class="col-sm-3 control-label">Credentials</label>
      <div class="col-sm-5">
        <input type="text" id="ssh_user" class="form-control" placeholder="Username">
      </div>
      <div class="col-sm-4 no-left-padding">
        <input type="password" id="ssh_password" class="form-control" placeholder="Password">
      </div>
    </div>
    <div class="form-group">
      <label class="col-sm-3 control-label">Auth Key</label>
      <div class="col-sm-5">
        <input type="text" id="ssh_key" class="form-control" placeholder="Key path">
      </div>
      <div class="col-sm-4 no-left-padding">
        <input type="password" id="ssh_key_password" class="form-control" placeholder="Key password">
      </div>
    </div>
    <hr>
  </div>
  <div id="connection_error" class="alert alert-danger"></div>
  <div class="form-group">
    <div class="col-sm-12">
      <button type="submit" class="btn btn-block btn-primary open-connection">Connect</button>
      <button type="button" id="close_connection_window" class="btn btn-block btn-default">Cancel</button>
    </div>
  </div>
</form>

Text Content

 * Rows
 * Structure
 * Indexes
 * Constraints
 * Query
 * History
 * Activity
 * Connection

Connect Disconnect
Table Information
Size:
Data size:
Index size:
Estimated rows:
 
 
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
Explain Query
 * Explain Query
 * Analyze Query

Please wait, query is executing...




Search Select filter = ≠ > ≥ < ≤ LIKE ILIKE IS NULL NOT NULL Apply

rows


PGWEB

v0.11.10

Scheme Standard SSH

--------------------------------------------------------------------------------

Enter server URL scheme

URL format: postgres://user:password@host:port/db?sslmode=mode
Read more on PostgreSQL connection string format.

Bookmark

Host


Username

Password

Database

SSL Mode
disable require verify-full

--------------------------------------------------------------------------------


SSH CONNECTION

Host


Credentials


Auth Key



--------------------------------------------------------------------------------


Connect Cancel
 * Copy Table Name
 * 
 * Export to JSON
 * Export to CSV
 * Export to XML
 * Export to SQL
 * 
 * Truncate Table
 * Delete Table

 * Copy View Name
 * 
 * Export to JSON
 * Export to CSV
 * Export to XML
 * 
 * Delete View

 * Export SQL dump

 * Unique Values
 * Unique Values + Counts
 * Numeric stats (min/max/avg)
 * Copy Column Name

 * Copy Value
 * Filter Rows By Value