Empower. Innovate. Transform.

  • Generating a UUID in Postgres for Insert statement?

    Generating a UUID in Postgres for Insert statement?

    UUID stands for universally unique identifier. Unlike auto generated ID’s it is long and includes both numeric and alphanumeric characters. TL;DR: gen_random_uuid(); Randomness of a UUID is not based on an authority, also there is a possibility to be duplicated, in practice, that provides a unique identifier to objects in database. UUID in PostgreSQL PostgreSQL…

  • What is the Format for the PostgreSQL Connection String

    What is the Format for the PostgreSQL Connection String

    Connection string is term PostgreSQL drivers use to connect specified database. In this article we will try to answer question What is the Format for the PostgreSQL Connection String? In general, database connection string in PostgreSQL is: As a note, that is not a JDBC connection string. For JDBC there is a different format, we…