YugabyteDB Tips
  • Home
  • About
  • Featured Videos

Category: SQL Functions

YugabyteDB Tips > SQL Functions

Extract Array Elements Into Rows

Jim KnicelyApril 16, 2022

YugabyteDB allows columns of a table to be defined as variable-length multidimensional arrays. The UNNEST() function can be used later to expand […]

Read More

Get an Estimated Table Row Count

Jim KnicelyApril 15, 2022

To display an up to date “current” row count of a table, we can run the classic SELECT COUNT(*) statement. Example: yugabyte=# […]

Read More

Enable Oracle’s Compatibility Functions and Packages in YSQL

Jim KnicelyApril 14, 2022

Are you migrating from Oracle to YugabyteDB? If so, Orafce is a very useful PostgreSQL Extension that allows you to implement some […]

Read More

Turn Your Table Data into JSON

Jim KnicelyApril 13, 2022

We learned in a previous tip how to export data into a file. Now let’s see how we can first convert the […]

Read More

Display Node Start Times

Jim KnicelyApril 13, 2022

The pg_postmaster_start_time() function returns the start time of the server where you execute it. Example: But your YugabyteDB database is most likely […]

Read More

Posts navigation

Older posts
Newer posts

NOTICE

This site is not affiliated, endorsed or associated with YugabyteDB. This site makes no claims on ownership of trademark rights. The author contributions on this site are licensed under CC BY-SA 3.0 with attribution required.

Find Us

Address
Here!

Hours
24×7

Recommended YugabyteDB Links

  • Home
  • Key Concepts
  • Docs
  • Blog
  • Forum
  • Content Library
  • Support



YugabyteDB Tips

Copyright 2025 - Knicely/Li