When you run a DML statement like an INSERT, UPDATE or DELETE, some number of rows are affected. Databases have various ways […]
Read More
Lists Functions Created by an Extension
We learned in a previous tip that we can ENABLE ORACLE’S COMPATIBILITY FUNCTIONS AND PACKAGES IN YSQL. That’s awesome! But what are […]
Read MoreWhich Character Data Types in YSQL Preserve Preceding or Trailing Spaces?
The following character data types are supported in YugabyteDB YSQL: varchar(n): variable-length string char(n): fixed-length, blank padded text, varchar: variable unlimited length While […]
Read MoreCreate a Read Only User
Postgres 14 introduced a set of predefined roles that provide access to certain, commonly needed, privileged capabilities and information. One of those […]
Read More