Latest In


OKBob - The Powerful Pager And Viewer For PostgreSQL

OKBob is a pager and viewer for PostgreSQL that allows you to view, search, and edit your data with ease. It's a command-line tool that is designed to work seamlessly with PostgreSQL, providing you with a fast and efficient way to manage your database.

Author:Tyreece Bauer
Reviewer:Gordon Dickerson
May 22, 2023
OKBobis a pager and viewer for PostgreSQL that allows you to view, search, and edit your data with ease. It's a command-line tool that is designed to work seamlessly with PostgreSQL, providing you with a fast and efficient way to manage your database.
OKBob is written in C and uses the ncurses library for terminal handling. It's easy to install and use, and comes with a wide range of features that make it an ideal tool for developers, database administrators, and anyone else who needs to work with PostgreSQL.

Key Features Of OKBob

Here are some of the key features of OKBob that make it such a powerful tool:

Fast And Efficient

OKBob is designed to be fast and efficient, allowing you to work with your data quickly and easily. It uses a variety of optimizations to ensure that it can handle even the largest databases with ease.


OKBob is highly customizable, allowing you to configure it to meet your specific needs. You can customize the colors, fonts, and other settings to create a personalized experience that works for you.

Multiple Views

OKBob allows you to view your data in multiple ways, including grid, tabular, and JSON formats. This makes it easy to work with your data in the way that makes the most sense for your needs.

Search And Filtering

OKBob includes powerful search and filtering features that make it easy to find the data you need. You can search for data by keyword, and filter your results based on a wide range of criteria.

Editing Capabilities

OKBob allows you to edit your data directly from the command line, making it easy to make changes to your database as needed. You can add, delete, and modify data with ease, without ever leaving the command line.

Multiple Language Support

OKBob supports multiple languages, including English, French, German, Italian, and Spanish. This makes it accessible to users around the world, regardless of their native language.
OKBob Github Post
OKBob Github Post

Installing OKBob

Installing OKBob is easy. Simply follow these steps:
  • Download the latest release from the OKBob GitHub repository.
  • Extract the contents of the archive to a directory of your choice.
  • Run the make command to compile the source code.
  • Run the sudo make install command to install OKBob on your system.
That's it! OKBob should now be installed on your system and ready to use.

Using OKBob

To use OKBob, simply run the pspg command followed by the name of your PostgreSQL database. For example, if your database is named my_database, you would run the following command:
  • pspg my_database
This will open OKBob and allow you to start working with your data.
Basic Navigation
Once you have OKBob open, you can use the following keys to navigate through your data:
  • Use the arrow keys to move up and down through your data.
  • Use the Page Up and Page Down keys to move through your data one page at a time.
  • Use the Home and End keys to move to the beginning or end of your data.

Searching And Filtering

To search for data in OKBob, simply press the / key and enter your search term. OKBob will automatically filter your data based on your search term.
You can also use the F2 key to open the filter dialog, which allows you to apply complex filters to your data. In the filter dialog, you can specify filter criteria based on multiple columns, and you can use operators like =, !=, <, >, and LIKE to refine your search.

Editing Data

OKBob allows you to edit your data directly from the command line, making it easy to make changes to your database. To edit a cell, simply navigate to the cell using the arrow keys, and then press the Enter key. This will put the cell into edit mode, and you can make your changes.
When you're finished editing, press the Esc key to save your changes and exit edit mode. If you want to cancel your changes, press the Ctrl+C key.

Customizing OKBob

OKBob is highly customizable, and you can configure it to meet your specific needs. To customize OKBob, you can create a configuration file in your home directory called .pspgconf. In this file, you can specify a wide range of options, including colors, fonts, key bindings, and more.

OKBob's User Interface

OKBob has a user-friendly interface that is easy to navigate and use. The interface is designed to be intuitive and customizable, making it easy to tailor to your specific needs. The interface displays data in a tabular format, making it easy to view large datasets. OKBob's interface also supports syntax highlighting and color-coded data, making it easy to read and understand your data.

OKBob's Keyboard Shortcuts

OKBob has a range of keyboard shortcuts that make it quick and easy to perform common tasks. These shortcuts can be customized to suit your preferences, making it easy to work efficiently. Some of the most useful shortcuts include navigating between cells using the arrow keys, entering edit mode with the Enter key, and canceling changes with the Ctrl+C key.

OKBob's Handling Of Large Datasets

OKBob is designed to handle large datasets efficiently, even when working with millions of rows of data. OKBob's search and filtering features make it easy to quickly find and analyze data within large datasets.
OKBob's interface also supports horizontal scrolling, making it easy to work with datasets that have many columns. Additionally, OKBob's customizable pagination options allow you to control how many rows are displayed on each page, making it easy to work with datasets of any size.

OKBob's Exporting And Importing Capabilities

OKBob has robust exporting and importing capabilities, making it easy to move data between different PostgreSQL databases or other tools. OKBob can export data in a range of formats, including CSV, JSON, SQL, and more. This makes it easy to share data with other tools or users.
Additionally, OKBob supports importing data from a range of sources, including files, URLs, and other databases. OKBob's import capabilities make it easy to quickly load data into a PostgreSQL database.
OKBob's exporting and importing capabilities are also highly customizable. You can configure the tool to export or import only specific data, using filters or queries. This makes it easy to extract specific subsets of data or to import data into specific tables.

OKBob's Compatibility With Different PostgreSQL Versions

OKBob is compatible with a range of different PostgreSQL versions, making it a versatile tool for managing PostgreSQL databases. OKBob is designed to work with PostgreSQL versions 9.3 and higher.
This includes support for PostgreSQL 13, the latest version of PostgreSQL as of 2023. OKBob is also compatible with a range of different PostgreSQL distributions, including, Postgres-XL, and more.
OKBob's compatibility with different PostgreSQL versions and distributions makes it a valuable tool for managing PostgreSQL databases, no matter what environment you are working in. Whether you are working with a legacy PostgreSQL database or a modern PostgreSQL distribution, OKBob can help you manage your data efficiently and effectively.

OKBob's Documentation And Support

OKBob has extensive documentation and support resources available to users. The documentation provides detailed information on how to install, configure, and use OKBob.
The documentation also includes information on keyboard shortcuts, customization options, and other features of the tool. The documentation is available online and is regularly updated to reflect changes and improvements to the tool.
In addition to the documentation, OKBob has a range of support resources available to users. The tool's GitHub page includes an issue tracker, where users can report bugs or request new features.
The issue tracker is regularly monitored by the OKBob development team, who are responsive to user feedback and suggestions. OKBob also has an active community of users, who provide support and guidance to other users through online forums and discussion groups.
For users who need more in-depth support, OKBob also offers consulting services. The consulting services provide customized support and training to users, helping them to get the most out of the tool. The consulting services are provided by experienced PostgreSQL professionals, who have extensive knowledge of the tool and the PostgreSQL ecosystem.

People Also Ask

What Types Of Queries Can I Run With OKBob?

OKBob supports a range of SQL queries, including SELECT, UPDATE, DELETE, and INSERT.

Can I Customize The Color Scheme Of OKBob's Interface?

Yes, OKBob's interface can be customized with a range of color schemes and fonts.

Does OKBob Support Connecting To Multiple PostgreSQL Databases At Once?

Yes, OKBob supports connecting to multiple PostgreSQL databases simultaneously.

What Level Of Support Is Available For OKBob?

OKBob has an active community of developers and users, with documentation and support available on its GitHub page.

How Does OKBob Handle Errors When Working With Large Datasets?

OKBob has built-in error handling and debugging capabilities, making it easier to identify and resolve errors when working with large datasets.


If you're looking for a powerful pager and viewer for PostgreSQL, look no further than OKBob. With its fast and efficient performance, powerful search and filtering capabilities, and flexible editing features, OKBob is an ideal tool for developers, database administrators, and anyone else who needs to work with PostgreSQL.
Whether you're working with a small database or a massive one, OKBob can help you get the job done quickly and easily. So why not give it a try today? With its ease of use and powerful features, OKBob is sure to become your go-to tool for PostgreSQL database management.
Jump to
Tyreece Bauer

Tyreece Bauer

A trendsetter in the world of digital nomad living, Tyreece Bauer excels in Travel and Cybersecurity. He holds a Bachelor's degree in Computer Science from MIT (Massachusetts Institute of Technology) and is a certified Cybersecurity professional. As a Digital Nomad, he combines his passion for exploring new destinations with his expertise in ensuring digital security on the go. Tyreece's background includes extensive experience in travel technology, data privacy, and risk management in the travel industry. He is known for his innovative approach to securing digital systems and protecting sensitive information for travelers and travel companies alike. Tyreece's expertise in cybersecurity for mobile apps, IoT devices, and remote work environments makes him a trusted advisor in the digital nomad community. Tyreece enjoys documenting his adventures, sharing insights on staying secure while traveling and contributing to the digital nomad lifestyle community.
Gordon Dickerson

Gordon Dickerson

Gordon Dickerson, a visionary in Crypto, NFT, and Web3, brings over 10 years of expertise in blockchain technology. With a Bachelor's in Computer Science from MIT and a Master's from Stanford, Gordon's strategic leadership has been instrumental in shaping global blockchain adoption. His commitment to inclusivity fosters a diverse ecosystem. In his spare time, Gordon enjoys gourmet cooking, cycling, stargazing as an amateur astronomer, and exploring non-fiction literature. His blend of expertise, credibility, and genuine passion for innovation makes him a trusted authority in decentralized technologies, driving impactful change with a personal touch.
Latest Articles
Popular Articles