PostgreSQL online

 


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

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, select, update and delete.

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