Does Google Cloud SQL for PostgreSQL support user defined functions?

[LiMing Lu]

PostgreSQL allows you to extend the database functionality with user-defined functions by using various procedural languages, which are often referred to as stored procedures.

With stored procedures you can create your own custom functions and reuse them in applications or as part of other database’s workflow.

Does Google Cloud SQL for PostgreSQL support user defined functions?

[wushawn]

Cloud SQL instance is the same as the functionality provided by a locally-hosted PostgreSQL instance. there are a few differences between them.

Unsupported features

• Any features that require SUPERUSER privileges

  An exception to this rule is made for the CREATE EXTENSION statement, but only for supported extensions.

• Custom background workers

• The psql client in Cloud Shell does not support operations that require a reconnection, such as connecting to a different database using the \c command.

Notable differences

• There are some PostgreSQL options and parameters that are not enabled for editing as Cloud SQL flags.

  To request the addition of a configurable Cloud SQL flag, use the Cloud SQL Discussion group.

As user-defined functions (UDFs) generally be used to deal with huge amount of data, in GCP the BigQuery is the production that using simple SQL—in a fraction of the time. It supports the UDFs. I believe it could meet your requirements.