Transfer data from PostgreSQL to Redis in a few clicks

by

Posted on by

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

Log in to PostgreSQL database.

Transfer data from PostgreSQL To Redis - Choose PostgreSQL and logon

Log in to Redis.

Move data from PostgreSQL To Redis - log in to Redis

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.

Convert data from PostgreSQL To Redis - transfer

Here you can Download RedisDataStudio