Difficulty: Beginner
Estimated Time: However long you like!

This scenario is a simple sandbox in which you can experiment with SQL in EDB Postgres Advanced Server.

When you start, the terminal window will automatically launch the psql command line client and connect to the pagila database in an Advanced Server 12 instance.

The pagila database is a port of the Sakila sample database which has been updated to be more Postgres idiomatic.

We hope you enjoyed playing with EDB Postgre Advanced Server! If you wish to install your own copy for futher evaluation, please visit the EDB download page.

EDB Postgres Advanced Server Sandbox

Sandbox

Use the terminal window to experiment with SQL and psql commands in EDB Postgres Advanced Server 12.

Try Oracle®-compatible queries:

select username, ROWNUM from staff;

...or Postgres queries:

select username, row_number() over () from staff;

For more information on Advanced Server's compatibility features, please see Database Compatibility for Oracle® Developers Reference Guide.

For more information on the SQL commands you can use in PostgreSQL, please see the SQL documentation.

For more information on the psql command line tool and how you can use it, please see the psql documentation.