Postgres online


This playground allows you to test postgres online. You can test Postgres queries online (PostgreSQL 13).

It is an SQL sandbox, it does not require installation, you can make SQL online. It can help to make small tests easily in a few seconds.

/!\ The database that you create is deleted after approximately 30 minutes of inactivity.

/!\ The database is limited to 20MB, if you exceed this limit, your database will be deleted.

How to test Postgres queries online?

  • Enter your SQL query in the editor, finally click on "Run" to execute it. The query result will be displayed below the editor .

  • You can also run only one query entered in the editor. To do this, simply select it before clicking on "Run".

  • If you want to export the results in csv format, click on "Export".

Code editor

You can share SQL snippet. Click on "Share snippet" to share your SQL code.
Your database will not be backed up, this only saves the editor code! This is useful for sharing SQL code.

The sql queries entered in the editor are saved so that you will find them during your next visits.
Warning, this is a local backup in your browser, it can be deleted at any time.

How to dump Postgres database ?

You can dump Postgres database to SQL file. Click on "Database > Dump DB to SQL" to export your Postgres DB.

About PostgreSQL

PostgreSQL is a free and open source object-relational database system. PostgreSQL has over 30 years of active development, it is a strong reputation for reliability and performance.

Export results to CSV

NULL string
Save and Share SQL snippet
Save SQL code in order to share it.
Your database will not be backed up, this only saves the editor code! This is useful for sharing SQL code.
Be careful, the data will be accessible to everyone, please do not save sensitive data.
Save SQL snippet
Your SQL snippet has been permanently saved and you (or anybody) can access with this link:
Choice a password to modify/delete this SQL snippet later Enter password to modify this SQL snippet. Enter password to delete this SQL snippet. Enter the new password for the fork.
You can report a bug or give feedback by adding a comment (below) or by clicking "Contact me" link (at the top right hand corner of the page).