Starting your coding environment
A machine is being prepared for you. This usually takes under a minute.
Free online PostgreSQL editor
JDoodle is an online IDE that has served the programming community since 2013. You write, compile, and run code in the browser for PostgreSQL and many other languages, without installing a toolchain.
What you see on this page is JDoodle’s free PostgreSQL editor. Write queries in the editor and run them against a real PostgreSQL server, with the results in a table beside them. You do not install PostgreSQL and you do not configure anything: the database is started for you, it is yours for the session, and it can be reset from the header when you want to begin again. Because it is a server of your own rather than a shared one, running a query needs a JDoodle account, which is free. You will see this called an online PostgreSQL compiler. SQL is not compiled the way Java or C is, so the honest word is editor: you write a query, JDoodle runs it against a real PostgreSQL server and shows you the rows that come back.
Online PostgreSQL editor
JDoodle’s PostgreSQL editor on this page highlights syntax, completes as you type, matches brackets, and folds blocks. It is an online PostgreSQL editor: you write a query here, then run it against the hosted database.
Frequently asked questions
Is JDoodle’s online PostgreSQL editor free?
Yes. Running PostgreSQL on JDoodle costs nothing. It does need an account, because the environment is a machine started for you rather than shared, and an account is free to create. Paid plans add more AI credits, longer sessions and faster workspaces.
Do I need to install PostgreSQL to use JDoodle?
No. JDoodle runs PostgreSQL on its servers. Open this page in a browser and execute.
Do I need an account to run PostgreSQL on JDoodle?
Yes, and it is free to create. PostgreSQL runs on a machine JDoodle starts for you and keeps for the length of your session, rather than on shared infrastructure, so it cannot be handed to somebody we do not know. Everything else on this page can be read without one.
Is the PostgreSQL database a real one?
Yes. Your queries run against a real PostgreSQL server, not an emulation of one, so behaviour, error messages and types are what you would get from PostgreSQL anywhere else. The database is yours for the session and can be reset from the header.
Input, interactive runs, files, and the rest of the editor work the same on every language. See the JDoodle IDE documentation.