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).
You can use the postgis extension for that click on "Database > Activate PostGis".
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.
/!\ 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.
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".
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.
You can dump Postgres database to SQL file. Click on "Database > Dump DB to SQL" to export your Postgres DB.
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 ...