Table viewer

​

Opening tables

1. Navigate to Table Viewer in the sidebar
2. Expand your server and database in the tree
3. Click any table name to open it

​

Viewing data

• Column headers: Clickable headers showing column names and data types
• Row data: All column values for each row
• Pagination controls: Navigate through large datasets
• Row counter: Total number of rows in the table

​

Virtual rendering

• Render only visible rows
• Maintain smooth scrolling performance
• Handle datasets of any size

​

Pagination

• Default page size: 100 rows
• Page size options: 50, 100, 200, 500 rows per page
• Navigation: Previous, Next, First, Last page buttons
• Page counter: Shows current page and total pages

​

Table schema

​

Column information

• Column name: The column identifier
• Data type: PostgreSQL data type (varchar, integer, timestamp, etc.)
• Nullable: Whether the column accepts NULL values
• Default value: Default value for new rows
• Primary key: Whether this column is part of the primary key

​

Indexes

• Index name: Unique identifier for the index
• Columns: Which columns are included
• Type: Index type (btree, hash, gin, gist)
• Unique: Whether the index enforces uniqueness

​

Constraints

• Primary keys: Unique row identifiers
• Foreign keys: References to other tables
• Unique constraints: Enforce unique values
• Check constraints: Validation rules

​

Editing data

1. Click the cell to select it
2. Type the new value
3. Press Enter to confirm or Escape to cancel

​

Adding rows

1. Click the Add Row button in the toolbar
2. Fill in values for each column
3. Click Save to insert the row

​

Deleting rows

1. Select rows using the checkboxes
2. Click the Delete Selected button
3. Confirm the deletion in the dialog

​

Exporting data

id,name,email,created_at
1,John Doe,john@example.com,2024-01-15 10:30:00
2,Jane Smith,jane@example.com,2024-01-16 14:22:00

[
  {
    "id": 1,
    "name": "John Doe",
    "email": "john@example.com",
    "created_at": "2024-01-15T10:30:00.000Z"
  },
  {
    "id": 2,
    "name": "Jane Smith",
    "email": "jane@example.com",
    "created_at": "2024-01-16T14:22:00.000Z"
  }
]

​

Filtering and sorting

​

Sorting

• First click: Sort ascending
• Second click: Sort descending
• Third click: Remove sorting

​

Filtering

1. Click the Filter icon in the column header
2. Enter your filter criteria
3. Press Enter to apply

• Equals: Exact match
• Contains: Partial match (case-insensitive)
• Starts with: Value begins with text
• Ends with: Value ends with text
• Greater than / Less than: Numeric and date comparisons

​

Table operations

​

Rename table

1. Right-click the table name in the schema tree
2. Select Rename
3. Enter the new name
4. Click Rename

​

Edit table structure

• Add/remove columns
• Change column types
• Add/remove indexes
• Modify constraints

​

Drop table

1. Right-click the table name
2. Select Drop Table
3. Confirm by typing the table name
4. Click Drop Table

​

Performance tips

​

Large tables

• Use pagination instead of loading all rows
• Apply filters to reduce the result set
• Create indexes on frequently queried columns
• Export in smaller batches

​

Virtual scrolling

• Scrolling remains smooth even with large page sizes
• Memory usage is optimized
• Initial load time is fast

​

Keyboard navigation

​

Next steps