---
title: "PostgreSQL | CoderPad"
description: "Learn more about PostgreSQL from CoderPad."
canonical: "https://coderpad.io/languages/postgresql/"
last_modified: "2023-05-10 09:35:37"
---
# PostgreSQL online IDE & code editor for technical interviews

Running PostgreSQL 12.4 – IntelliSense is not available

### Experience the PostgreSQL IDE yourself

See just how easy and intuitive CoderPad Interview is to use below.

[Launch the environment](https://embed.coderpad.io/sandbox?question_id=247191&use_question_button)

## Guidelines to use PostgreSQL in this online IDE

PostgreSQL mode spins up a PostgreSQL server with a default database with some sample data in it. The schema of the default database looks like:

```
employees                             projects
+---------------+---------+           +---------------+---------+
| id            | int     |<----+  +->| id            | int     |
| first_name    | varchar |     |  |  | title         | varchar |
| last_name     | varchar |     |  |  | start_date    | date    |
| salary        | int     |     |  |  | end_date      | date    |
| department_id | int     |--+  |  |  | budget        | int     |
+---------------+---------+  |  |  |  +---------------+---------+
                             |  |  |
departments                  |  |  |  employees_projects
+---------------+---------+  |  |  |  +---------------+---------+
| id            | int     |<-+  |  +--| project_id    | int     |
| name          | varchar |     +-----| employee_id   | int     |
+---------------+---------+           +---------------+---------+
Code language: PostgreSQL SQL dialect and PL/pgSQL (pgsql)
```

The database is reset when the “Reset” button is clicked, or the pad switches to another language.

### Output format

Having trouble seeing query results because of line wrapping? Try the`\x`expanded output option:

`SELECT * from employees \x`

yields:

```
-[RECORD 1 ]-+----------
id            | 1
first_name    | John
last_name     | Smith
salary        | 20000
department_id | 1
-[RECORD 2 ]-+----------
id            | 2
first_name    | Ava
last_name     | Muffinson
salary        | 10000
department_id | 5
...
Code language: PostgreSQL SQL dialect and PL/pgSQL (pgsql)
```

## Need a better way to interview candidates?

[Request a demo](https://coderpad.io/sales/)