Want to transfer data from PostgreSQL to Redis without programming?
Using RedisDataStudio, a native GUI tool, you can transfer data from PostgreSQL to Redis easily and fast, just a few mouse clicks!
Support Windows, Linux, macOS.
Transfer data from PostgreSQL To Redis
Start RedisDataStudio.
Log in to Redis.
Start a “DB to Redis” task.
Log in to PostgreSQL database.
You can transfer data from PostgreSQL table or sql query results to Redis, in 3 formats.
For example, you have a PostgreSQL table “users”, 2 records in it.
| id | name | age |
| 1 | Fred | 25 |
| 2 | Tom | 28 |
1. Store a record as JSON-encoded string in a single key.
| Key | Value |
| user:1 | {“name”:”Fred”,”age”:25} |
| user:2 | {“name”:”Tom”,”age”:28} |
2. Store a record as a Redis hash key, and each field of the record as a Redis hash key’s field.
| Key | Field | Value |
| user:1 | ||
| name | Fred | |
| age | 25 | |
| user:2 | ||
| name | Tom | |
| age | 28 |
3. Store each record as a JSON string in a Redis hash.
| Key | Field | Value |
| users | ||
| 1 | {“name”:”Fred”,”age”:25} | |
| 2 | {“name”:”Tom”,”age”:28} |
Transfer data from PostgreSQL to Redis.
Here you can Download RedisDataStudio