tutobase

Sign In

1

Lesser Known PostgreSQL Features

hakibenita.com/postgresql...

  • postgres

  • blog post

  • tutorial

  • with code

Description:

Table of Contents

  • Get the Number of Updated and Inserted Rows in an Upsert
  • Grant Permissions on Specific Columns
  • Match Against Multiple Patterns
  • Find the Current Value of a Sequence Without Advancing It
  • Use \copy With Multi-line SQL
  • Prevent Setting the Value of an Auto Generated Key
  • Two More Ways to Produce a Pivot Table
  • Dollar Quoting
  • Comment on Database Objects
  • Keep a Separate History File Per Database
  • Autocomplete Reserved Words in Uppercase
  • Sleep for Interval
  • Get the First or Last Row in a Group Without Sub-Queries
  • Generate UUID Without Extensions
  • Generate Re
+ Expand description

Posted by NaN_Loss 21 days ago

save post

Sign in or register to leave a comment

No comment yet

Popular topics

  • transformers

  • ConvNets

  • MachineLearningTheory

  • NLP

  • SGD

  • regularization

  • python

  • NeuralNetworks

  • Backpropagation

  • math

  • GANs

  • ReinforcementLearning

  • LSTMs

  • ComputerVision

  • VariationalAutoencoder

Popular tags

  • blog post

  • with code

  • tutorial

  • notebook(s)

  • video playlist

  • graduate course

  • beginner

  • book

  • video

  • advanced

  • opinion

  • free course

  • annotated paper

  • library

  • news