Relative Content

Tag Archive for pythonpostgresql

How to encrypt data with Postgresql pgp_sym_encrypt in Python?

Now I want to implement the same logic in Python, so that the encrypted data can be decrypted by PostgreSQL. I tried to solve this problem using GPG, but even after supplementing all the default parameters, it still cannot be decrypted by PostgreSQL.

Convert a string num to an int and write to an SQL file? [duplicate]

This question already has answers here: Search and replace a line in a file in Python (13 answers) Closed last month. I have a price column in my .sql file that is currently a string of numbers (prices). I want to use python to modify the string of numbers and convert them into actual numbers […]