Select your cookie preferences

We use essential cookies and similar tools that are necessary to provide our site and services. We use performance cookies to collect anonymous statistics, so we can understand how customers use our site and make improvements. Essential cookies cannot be deactivated, but you can choose “Customize” or “Decline” to decline performance cookies.

If you agree, AWS and approved third parties will also use cookies to provide useful site features, remember your preferences, and display relevant content, including relevant advertising. To accept or decline all non-essential cookies, choose “Accept” or “Decline.” To make more detailed choices, choose “Customize.”

PL/pgSQL reference conventions - Amazon Redshift
This page has not been translated into your language. Request translation

PL/pgSQL reference conventions

In this section, you can find the conventions that are used to write the syntax for the PL/pgSQL stored procedure language.

Character Description
CAPS Words in capital letters are keywords.
[ ] Brackets denote optional arguments. Multiple arguments in brackets indicate that you can choose any number of the arguments. In addition, arguments in brackets on separate lines indicate that the Amazon Redshift parser expects the arguments to be in the order that they are listed in the syntax.
{ } Braces indicate that you are required to choose one of the arguments inside the braces.
| Pipes indicate that you can choose between the arguments.
red italics Words in red italics indicate placeholders. Insert the appropriate value in place of the word in red italics.
. . . An ellipsis indicates that you can repeat the preceding element.
' Words in single quotation marks indicate that you must type the quotes.
PrivacySite termsCookie preferences
© 2025, Amazon Web Services, Inc. or its affiliates. All rights reserved.