# How to use data storage for PostgreSQL

**URL:** <https://community.integray.com/t/how-to-use-data-storage-for-postgresql/96>\
**Category:** Platform discussions\
**Tags:** connector\
**Created:** [August 3, 2023, 12:02pm UTC](https://community.integray.com/t/how-to-use-data-storage-for-postgresql/96 "2023-08-03T12:02:57Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Moerani](https://avatars.discourse-cdn.com/v4/letter/m/e79b87/32.png) [@Moerani](https://community.integray.com/u/Moerani)\
**Post date:** [August 3, 2023, 12:02pm UTC](https://community.integray.com/t/how-to-use-data-storage-for-postgresql/96/1 "2023-08-03T12:02:57Z")

</div>

Hi, my database statement is SELECT column1, column2 FROM table  
how to insert data into Data storage column?

I am primarily interested in PostgreSQL.

---

<div class="post-metadata">

**Author:** ![tomas](https://avatars.discourse-cdn.com/v4/letter/t/439d5e/32.png) [@tomas](https://community.integray.com/u/tomas)\
**Post date:** [August 3, 2023, 1:23pm UTC](https://community.integray.com/t/how-to-use-data-storage-for-postgresql/96/2 "2023-08-03T13:23:35Z")

</div>

Hi,

Yo have to specify which column from output schema will be added to data checkpoint. We take the last (not the biggest) value in the return array and put it into data checkpoint. Therefore you have to ensure proper sort when returning the data using “order by” clause in SQL.

 ![image](https://europe1.discourse-cdn.com/flex017/uploads/integray/original/1X/8f30e9327993271784e597018b6d26bb639a2d43.png)

Tomas.

---

<div class="post-metadata">

**Author:** ![system](https://avatars.discourse-cdn.com/v4/letter/s/bcef8e/32.png) [@system](https://community.integray.com/u/system)\
**Post date:** [August 10, 2023, 1:24pm UTC](https://community.integray.com/t/how-to-use-data-storage-for-postgresql/96/3 "2023-08-10T13:24:12Z")

</div>

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.