---
title: "PutSchemaAnnotation"
description: "Create or replace a schema annotation"
canonical: "https://pgbeam.com/docs/go-sdk/schemaannotations/putSchemaAnnotation"
last-updated: "2026-10-24T21:15:09.000Z"
---

# PutSchemaAnnotation

> Create or replace a schema annotation

URL: https://pgbeam.com/docs/go-sdk/schemaannotations/putSchemaAnnotation

{/* Auto-generated from OpenAPI. Do not edit. Run `pnpm generate:sdk-docs` to regenerate. */}

Attaches an operator-written description to a table (omit column_name) or a column. Keyed by (schema_name, table_name, column_name); an existing annotation with the same key is replaced.

## Usage

```go
result, err := client.Schemaannotations.PutSchemaAnnotation(ctx, "prj_xxx", pgbeam.SchemaAnnotationInput{
    TableName: "users",
    Description: "Primary customer account. One row per signed-up user.",
  })
```

## Parameters

| Parameter        | Type                           | Required | Description                                                  |
| ---------------- | ------------------------------ | -------- | ------------------------------------------------------------ |
| ctx              | `context.Context`              | Yes      | Request context                                              |
| projectID        | `string`                       | Yes      | Unique project identifier (prefixed, e.g. prj_xxx).          |
| body             | `pgbeam.SchemaAnnotationInput` | Yes      | Request body                                                 |
| body.SchemaName  | `*string`                      | No       | Optional schema. Null or empty matches the unqualified form. |
| body.TableName   | `string`                       | Yes      | Relation (table or view) the annotation describes.           |
| body.ColumnName  | `*string`                      | No       | Optional column. Null describes the table itself.            |
| body.Description | `string`                       | Yes      | The operator-written description text.                       |

## Response

`(*pgbeam.SchemaAnnotation, error)`: the created or updated annotation.

## Example

```go
import pgbeam "go.pgbeam.com/sdk"

client := pgbeam.NewClient(&pgbeam.ClientOptions{
  APIKey: "pbu_...",
})

schemaName := "public"
columnName := "email"
result, err := client.Schemaannotations.PutSchemaAnnotation(ctx, "prj_xxx", pgbeam.SchemaAnnotationInput{
    TableName: "users",
    Description: "Primary customer account. One row per signed-up user.",
    SchemaName: &schemaName,
    ColumnName: &columnName,
  })
if err != nil {
  log.Fatal(err)
}
fmt.Println(result)
```

## Errors

| Status | Description                                                                                                                                                                                                                                                                                           |
| ------ | ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| 400    | The request was rejected. `code` is `INVALID_INPUT`, and `errors` names the offending fields when the failure was a validation one.                                                                                                                                                                   |
| 401    | Missing or invalid authentication. `code` is `UNAUTHORIZED`.                                                                                                                                                                                                                                          |
| 403    | The caller is authenticated but not allowed to perform this operation. `code` is `FORBIDDEN` when the caller's role is insufficient, and `PLAN_LIMIT_REACHED` when the organization's plan is what stands in the way. The two are answered differently, so branch on the code rather than the status. |
| 404    | The resource does not exist, or the caller is not entitled to know that it does. `code` is `NOT_FOUND`.                                                                                                                                                                                               |
| 413    | The request body exceeds the 2 MB limit. `code` is `PAYLOAD_TOO_LARGE`.                                                                                                                                                                                                                               |
| 415    | The request body is not JSON, or carries a body without declaring a Content-Type. `code` is `UNSUPPORTED_MEDIA_TYPE`.                                                                                                                                                                                 |
| 429    | Rate limited. `code` is `RATE_LIMITED`.                                                                                                                                                                                                                                                               |
| 500    | The request failed for a reason on our side. `code` is `INTERNAL_ERROR`. Quote `request_id` when reporting it.                                                                                                                                                                                        |