# Access data in PostgreSQL

In order to make the Data Observatory subscriptions accessible in your PostgreSQL database, first of all CARTO needs to create and register your subscriptions in your CARTO account. Once this first step has been done, Admin users of your CARTO organization will be able to see the list of active subscriptions in the [Data Observatory section](/carto-user-manual/settings/data-observatory.md) in Settings.

<figure><img src="/files/rcxKyYKEQQNS4jC0p7an" alt=""><figcaption></figcaption></figure>

Once your subscriptions have been created, the CARTO team will proceed with the data transfers so to make the data accessible directly on your PostgreSQL database. **Please contact your CARTO representative** if you need to start this process on demand (e.g. public data subscriptions).

In order to make your subscriptions available in your PostgreSQL database, CARTO will share you access to the data in an GCS bucket. We will give you the instructions in order to create the tables in the PostgreSQL database by loading the files directly from the GCS bucket.

{% hint style="info" %}
As a prerequisite, you should have **PSQL** installed and working from the terminal.
{% endhint %}

In order to use the data from your Data Observatory subscriptions that have been transferred directly to your PostgreSQL database you should not use the Data Observatory tabs in Data Explorer, Workflows or Builder, but directly your own PostgreSQL connections.

### Access the data from your data warehouse connection in CARTO

Once the transfer has been completed, you will be able to explore your subscription directly from your data warehouse in the [Data Explorer](/carto-user-manual/data-explorer.md):

<figure><img src="/files/vfqzfv4i1o0C45DcURnl" alt=""><figcaption></figcaption></figure>


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.carto.com/carto-user-manual/data-observatory/accessing-your-subscriptions-from-your-data-warehouse/access-data-in-postgresql.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.