-
How to Create a Read Only User in PostgreSQL
In this article we are going to discuss, how to create read only user in PostgreSQL. Reporting users, or interns, or read only applications need a read only user. A read only user is: But not able to: Read Only User and Role User and role is same thing in PostgreSQL, user has a login…
-
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…
-
Copying PostgreSQL Database to Another Server
Even it is not a day to day operation for a database administrator database copying is one of the mandatory skills. In this article we will talk about copying PostgreSQL database to another server. TL;DR pg_dump -C -h localhost -U localuser dbname | psql -h remotehost -U remoteuser dbname Dumping SQL pg_dump utility is included…