Drop Postgres Index on ObjectRocket

Introduction If you’re managing a PostgreSQL database, there may be times when you need to remove an index from a table. Unused or unnecessary indexes don’t serve any practical purpose, and you can free up space by deleting them; however, it’s important to know how to handle the removal safely. In this article, we’ll show … Continued

Change Postgres User to Superuser

Introduction When you’re working with PostgreSQL, you may need to alter a user’s permission to give them elevated “superuser” privileges. It’s easy to make this change with the help of the ALTER USER command. In this article, we’ll show you how to change a Postgres user to a superuser, and we’ll also show you how … Continued

Update Postgres Data using PHP on ObjectRocket

Introduction If you’re creating a PHP application that interacts with a Postgres instance on ObjectRocket, you might need your application to update Postgres data. Fortunately, this task couldn’t be easier. In this article, we’ll show you how to update Postgres data using PHP on ObjectRocket, and we’ll provide sample code to get you started. Prerequisites … Continued

DELETE Postgres data using PHP on ObjectRocket

Introduction If you’re writing PHP code that will interact with PostgreSQL, it’s important to know how to perform certain database operations. One key operation that you should be able to execute from an application is the deletion of records. In this article, we’ll show you how to delete Postgres data using PHP on ObjectRocket and … Continued

Query Postgres data using PHP on ObjectRocket

Introduction If your PHP applications interact with a PostgreSQL database, you may want the ability to execute some queries from these applications. Fortunately, this task is easy to accomplish. In this article, we’ll explain how to query Postgres data using PHP on ObjectRocket. Our step-by-step instructions are accompanied by code examples to get you started … Continued

Create a Postgres Table on ObjectRocket

Introduction If you’re getting started with a Postgres instance on ObjectRocket, one of the first tasks you’ll probably need to do is create a table. Fortunately, the process is a very simple one. In this article, we’ll show you how to create a Postgres table on ObjectRocket, providing detailed instructions for each step of the … Continued

Connect GoLang to Postgres on ObjectRocket

Introduction If you’re developing applications using GoLang, you might want to interact with a PostgreSQL database from those applications. Fortunately, it just takes a few simple steps to install and configure the items you need to make this connection. In this article, we’ll show you how to connect GoLang to Postgres on ObjectRocket, providing detailed … Continued

Insert Postgres Data using PHP on ObjectRocket

Introduction When you interact with your PostgreSQL database from a PHP application, you’ll probably want to perform some common database operations in your code, such as inserting, updating, deleting and querying data. In this article, we’ll focus on the insert operation. We’ll show you how to insert Postgres data using PHP on ObjectRocket, providing detailed … Continued

Connect Java to Postgres on ObjectRocket

Introduction If you’re a Java developer planning to work with a Postgres database in your applications, the first thing you’ll need to do is create the necessary connections. Fortunately, the task of connecting Java to Postgres is an easy one. In this article, we’ll show you how to connect Java to Postgres on ObjectRocket with … Continued

Import CSV into Postgres on ObjectRocket

Introduction When you need to import data into a Postgres database, a common way to perform bulk imports is to use a comma-delimited, or CSV, file. With a CSV file, you can quickly load the contents of a file into the PostgreSQL table of your choice. In this article, we’ll explain how to import a … Continued

Keep in the know!

Subscribe to our emails and we’ll let you know what’s going on at ObjectRocket. We hate spam and make it easy to unsubscribe.