PostgreSQL online

 


This playground allows you to test postgres online (PostgreSQL 11.10).

You can directly use the editor above to run queries directly to a Postgresql database. You can run the following statements with postgresql-specific syntax: create table, create view, create index, explain, vacuum, select, update and delete.

It is not possible to use transactions (The connection is not persistent).

This tool does not allow storing persistent data (only a few minutes), it is just a PostgreSQL sandbox. It can help to make small tests easily, you can test Postgres queries online in a few seconds without installation. Your data will pass through the network, be careful not to use sensitive data.

Autocomplete: Ctrl-space for autocomplete.

Usage constraints:

/!\ 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 a strong reputation for reliability and performance thanks to over 30 years of community development. It is available for macOS Server, Linux, FreeBSD, OpenBSD, and Windows.

PostgreSQL can be used as the primary data store or data warehouse for many websites, mobile applications ...



Export results to CSV

Separator
NULL string
Header
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:
Password
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).

Comments




Arnold Wilson-2021-01-20 18:46
Seeking to educate myself further in Postgres SQL
and user books or tutorials.
Seeking how Postgres fits in with Amaxon Aurora


Co-2021-02-25 17:37
This error keeps popping up suddenly when in the middle of working with a tiny postgresql db I created
password authentication failed for user ""

Then I cant get back into the db and have to start all over.
But sometimes that error appears again and again no matter how often I refresh the browser. Like for the last ten minutes.
And I cant get the sandbox to run again.
How can I avoid this?


Luc CHAUVIERE-2021-03-12 07:44
Thank you for this powerfull tool.

2 tips for your documentation :
Add the keyword EXPLAIN (it runs!)
It seams that the real current version of the DB is PG 11.10 (?)

Can you add the fonctionalities around VACUUM ?


Cyril (admin)-2021-03-12 13:48
Hello,

Thank you for your feedback!!
I had to change the version of postgres, and forgot to update the documentation. This is corrected!
You can already execute vacuum. Can you detail?