How do I import my own database into Postgresql?

Runtime Framework
1

Hi,

I’m working on a trivia game. I need a question database for this game. When I examined the documentation, it was mentioned how to store user data by performing client operations with the storage engine.

I want to import a database in CSV format, which I already have, into Postgresql.

I’m running Nakama with docker compose. How can I import my database in csv format into the Postgresql database with some CLI operations in the server?

Thank you,

2

Hello @sezer, we recommend against custom tables, I think the best/easiest way to do it is to create some code in one of the runtimes’s InitModule that parses the CSV file and uses the Storage Engine APIs to create entries for these questions that can then be retrieved using the same APIs.

Hope this helps.