[google-cloud-sql-discuss] Re: Does Google Cloud SQL for PostgreSQL support user defined functions?

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.

On Thursday, October 22, 2020 at 3:05:14 PM UTC-4 LiMing Lu wrote:

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?

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/8c3614f3-6f98-472b-9835-b0eec54b5045n%40googlegroups.com.