Creating a table in database in BigAnimal

In the last article we saw on how do we connect to the BigAnimal and how we create a database. In this article we will be populating the table with sample data and querying it.

You can access the last article over here

Create a table:

Create a table named associates for storing the status of the employees either active or non active.

CREATE TABLE employees(
  id INTEGER,
  status STRING,
  PRIMARY KEY (id)
);

Populate the database with some employees status and their ids

INSERT INTO employees (id, status) VALUES
  (1, 'active'),
  (2, 'inactive'),
  (3, 'active'),
  (4, 'terminated');

Querying on the table:

The below query will display the active employees

SELECT id, status
FROM employees
WHERE status = 'active';

Similarly you can make more tables in the database, populate the data and then query over the data.

References:

1. https://www.postgresql.org/docs/
2. https://www.enterprisedb.com/docs/biganimal/latest/free_trial/quickstart/