We are no longer accepting contributions to Documentation. Please see our post on meta.

postgresql

Postgres cryptographic functions 9.6

topic discuss
8.4
9.0
9.1
9.2
9.3
9.4
9.5
9.6

In Postgres, cryptographic functions can be unlocked by using pgcrypto module. CREATE EXTENSION pgcrypto;

This draft deletes the entire topic.

Examples

  • 0
    digest
    0

    DIGEST() functions generate a binary hash of the given data. This can be used to create a random hash.

    Usage: digest(data text, type text) returns bytea

    Or: digest(data bytea, type text) returns bytea

    Examples:

    • SELECT DIGEST('1', 'sha1')

    • SELECT DIGEST(CONCAT(CAST(current_timestamp AS TEXT), RANDOM()::TEXT), 'sha1')

    edited Mar 1 at 8:55
    discuss
Please consider making a request to improve this example.

Syntax

Syntax

Parameters

Parameters

Remarks

Remarks

edited Mar 1 at 8:55
Still have a question about Postgres cryptographic functions? Ask Question

Topic Outline


    We are no longer accepting contributions to Documentation. Drafts cannot be modified.