In the Create Schema dialog, specify a name of usa.
You will be logging in with the default user name of postgres.Įnter the password you defined earlier for the postgres account when you installed the software.
How to test Postgres queries online?Įnter your SQL query in the editor, finally click on "Run" to execute it. !\ The database is limited to 20MB, if you exceed this limit, your database will be deleted. !\ The database that you create is deleted after approximately 30 minutes of inactivity. Your data will pass through the network, be careful not to use sensitive data.Īutocomplete: Ctrl-space for autocomplete. It can help to make small tests easily, you can test Postgres queries online in a few seconds without installation. This tool does not allow storing persistent data (only a few minutes), it is just a PostgreSQL sandbox. You can use the postgis extension for that click on "Database > Activate PostGis". It is not possible to use transactions (The connection is not persistent).
You can run the following statements with postgresql-specific syntax: create table, create view, create index, explain, vacuum, select, update and delete. You can directly use the editor above to run queries directly to a Postgresql database.
This playground allows you to test postgres online (PostgreSQL 11.10).