add a '-j' switch to be able to load the loaded data as jsonb field

Networks-Learning / stackexchange-dump-to-postgres

Python scripts to import StackExchange data dump into Postgres DB.

MIT License

83 stars 29 forks source link

add a '-j' switch to be able to load the loaded data as jsonb field #10

Closed madtibo closed 5 years ago

madtibo commented 6 years ago

add a jsonfield column of type jsonb to every table by default

madtibo commented 6 years ago

Yes, it was definitely an artefact! It is now corrected.

musically-ut commented 6 years ago

I've tested this and merged it into the branch feat-postgresql-9.4. I don't think that PostgreSQL 9.3 (the last supported version) supports jsonb field-type but I haven't verified it.

In any case, as the EOL of 9.3 is this very month, I will merge it in as soon as 9.3 becomes unsupported.

Thanks!

madtibo commented 6 years ago

You are right, jsonb is a 9.4 feature. great that everything is functional :-)

madtibo commented 5 years ago

@musically-ut 9.3 is now unsupported, could we merge this PR now?

musically-ut commented 5 years ago

Thanks for the ping, merged! \o/