CODEWITHSUNDEEP
postgresqlsqldatatypespublic-key
ma11hew28
ma11hew28

Reputation: 126457

PostgreSQL datatype for public key?

What PostgreSQL datatype should we use for a table column that stores public keys?

Should we store it as text base64-encoded (in the format that the application server receives it from the client), or should the application server convert it to data and have the database store it as a blob?

Upvotes: 1

Views: 2146

Answers (1)

Stelios
Stelios

Reputation: 1112

I would say store them as bytea type.

Public keys are actually a binary blob that has been base64 encoded when exported using the armor option.

Upvotes: 1

Related Questions