When you issue a CREATE SEQUENCE statement in a session, the current session user becomes the owner of the seqeunce. Example: yugabyte=# […]
Read MoreWhen you issue a CREATE SEQUENCE statement in a session, the current session user becomes the owner of the seqeunce. Example: yugabyte=# […]
Read MoreThe ANALYZE command collects statistics about the contents of tables in the database, and stores the results in the pg_statistic system catalog. These […]
Read MoreIn the previous tip GENERATE A RANDOM TIMESTAMP BETWEEN TWO TIMESTAMPS, we learned how to create a function to do just that. […]
Read MoreIn the previous tip GENERATE A RANDOM STRING, we learned how to create a function to do just that. In that version […]
Read MoreIn PostgreSQL, tablespaces allow administrators to specify where on a disk specific tables and indexes should reside based on how users want […]
Read More