Compare database schema | Neon Postgres Docs

GET/projects/{project_id}/branches/{branch_id}/compare_schemaCompare database schema

Compares the schema from the specified database with another branch's schema.

Parameters

project_idstringpathrequired

The Neon project ID

pattern ^[a-z0-9-]{1,60}$

branch_idstringpathrequired

The branch ID

pattern ^[a-z0-9-]{1,60}$

base_branch_idstringquery

The branch ID to compare the schema with

pattern ^[a-z0-9-]{1,60}$

db_namestringqueryrequired

Name of the database for which the schema is retrieved

lsnstringquery

The Log Sequence Number (LSN) for which the schema is retrieved

timestampstring · date-timequery

The point in time for which the schema is retrieved

base_lsnstringquery

The Log Sequence Number (LSN) for the base branch schema

base_timestampstring · date-timequery

The point in time for the base branch schema

Responses

objectBranchSchemaCompareResponse

diffstring

Unified diff of the SQL schema changes between the compared branches.

Example response

{
  "diff": "string"
}

defaultGeneral Error. The request may or may not be safe to retry, depending on the HTTP method, response status code, and whether a response was received. - If no response is returned from the API, a network error or timeout likely occurred. - In some cases, the request may have reached the server and been successfully processed, but the response failed to reach the client. As a result, retrying non-idempotent requests can lead to unintended results. The following HTTP methods are considered non-idempotent: `POST`, `PATCH`, `DELETE`, and `PUT`. Retrying these methods is generally **not safe**. The following methods are considered idempotent: `GET`, `HEAD`, and `OPTIONS`. Retrying these methods is **safe** in the event of a network error or timeout. Any request that returns a `503 Service Unavailable` response is always safe to retry. Any request that returns a `423 Locked` response is safe to retry. `423 Locked` indicates that the resource is temporarily locked, for example, due to another operation in progress. application/json

objectGeneralError

codestringrequired

default ""

messagestringrequired

Error message

request_idstring

Unique identifier for the request, useful for debugging. You can set this value manually by including an `X-Request-ID` header in the request. If not provided, the value will be generated automatically.

Example response

{
  "code": "",
  "message": "string",
  "request_id": "string"
}

Examples

project_idrequiredpath parameter

branch_idrequiredpath parameter

base_branch_idquery parameter

db_namerequiredquery parameter

lsnquery parameter

timestampquery parameter

base_lsnquery parameter

base_timestampquery parameter

curl -X GET 'https://console.neon.tech/api/v2/projects/string/branches/string/compare_schema?base_branch_id=string&base_lsn=string&base_timestamp=2022-11-30T20%3A09%3A48Z&db_name=string&lsn=string&timestamp=2022-11-30T20%3A09%3A48Z'

const response = await fetch('https://console.neon.tech/api/v2/projects/string/branches/string/compare_schema?base_branch_id=string&base_lsn=string&base_timestamp=2022-11-30T20%3A09%3A48Z&db_name=string&lsn=string&timestamp=2022-11-30T20%3A09%3A48Z', { method: 'GET' });
const data = await response.json();

const response = await fetch('https://console.neon.tech/api/v2/projects/string/branches/string/compare_schema?base_branch_id=string&base_lsn=string&base_timestamp=2022-11-30T20%3A09%3A48Z&db_name=string&lsn=string&timestamp=2022-11-30T20%3A09%3A48Z', { method: 'GET' });
console.log(await response.json());

import requests

response = requests.request("GET", "https://console.neon.tech/api/v2/projects/string/branches/string/compare_schema?base_branch_id=string&base_lsn=string&base_timestamp=2022-11-30T20%3A09%3A48Z&db_name=string&lsn=string&timestamp=2022-11-30T20%3A09%3A48Z")
print(response.json())

package main

import (
	"context"
	"net/http"
)

func main() {
	ctx := context.Background()
	req, err := http.NewRequestWithContext(ctx, "GET", "https://console.neon.tech/api/v2/projects/string/branches/string/compare_schema?base_branch_id=string&base_lsn=string&base_timestamp=2022-11-30T20%3A09%3A48Z&db_name=string&lsn=string&timestamp=2022-11-30T20%3A09%3A48Z", nil)
	if err != nil {
		panic(err)
	}
	resp, err := http.DefaultClient.Do(req)
	if err != nil {
		panic(err)
	}
	defer resp.Body.Close()
}

<?php
$request = curl_init("https://console.neon.tech/api/v2/projects/string/branches/string/compare_schema?base_branch_id=string&base_lsn=string&base_timestamp=2022-11-30T20%3A09%3A48Z&db_name=string&lsn=string&timestamp=2022-11-30T20%3A09%3A48Z");
curl_setopt($request, CURLOPT_CUSTOMREQUEST, "GET");
$response = curl_exec($request);
curl_close($request);

var request = HttpRequest.newBuilder(URI.create("https://console.neon.tech/api/v2/projects/string/branches/string/compare_schema?base_branch_id=string&base_lsn=string&base_timestamp=2022-11-30T20%3A09%3A48Z&db_name=string&lsn=string&timestamp=2022-11-30T20%3A09%3A48Z"))
    .method("GET", HttpRequest.BodyPublishers.noBody())
    .build();
var response = HttpClient.newHttpClient().send(request, HttpResponse.BodyHandlers.ofString());

require 'net/http'

uri = URI("https://console.neon.tech/api/v2/projects/string/branches/string/compare_schema?base_branch_id=string&base_lsn=string&base_timestamp=2022-11-30T20%3A09%3A48Z&db_name=string&lsn=string&timestamp=2022-11-30T20%3A09%3A48Z")
request = Net::HTTPGenericRequest.new("GET", false, true, uri)
response = Net::HTTP.start(uri.hostname, uri.port, use_ssl: true) { |http| http.request(request) }

using var client = new HttpClient();
using var request = new HttpRequestMessage(HttpMethod.Get, "https://console.neon.tech/api/v2/projects/string/branches/string/compare_schema?base_branch_id=string&base_lsn=string&base_timestamp=2022-11-30T20%3A09%3A48Z&db_name=string&lsn=string&timestamp=2022-11-30T20%3A09%3A48Z");
using var response = await client.SendAsync(request);

{
  "diff": "string"
}

{
  "code": "",
  "message": "string",
  "request_id": "string"
}