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 MoreShow the Number of YSQL Connections per Node via the Command Line
We learned in the tip LIST THE SERVERS IN YOUR CLUSTER that in YSQL we can list the nodes (hosts) in our […]
Read More