CREATE statements are used to declaratively create tables, views, functions etc.
If you went through the
psql section of the tutorial, you might have executed some of these commands:
Example of PostgreSQL CREATE DATABASE
In order to create a new database in Postgres, you can run the following statement.
CREATE DATABASE myapp;
We can verify the above command by executing the following in
Example of PostgreSQL CREATE TABLE
Next up, to create a new table, we can follow the syntax of
CREATE TABLE <table_name>(column_name data_type constraints);
CREATE TABLE users(id integer,name text,age integer,is_active boolean);
Once the table is created, you can verify this using
psql by executing the following command:
It will return something like this:
List of relationsSchema | Name | Type | Owner--------+-------+-------+----------public | users | table | postgres(1 row)
Note: By default, all the statements are executed against the
Example of PostgreSQL CREATE USER
CREATE USER praveen
This would create a user called
praveen. You can also assign the user a role while creating.
CREATE USER praveen with SUPERUSER;
The above command gives the user super user privilege.
- Build apps and APIs 10x faster
- Built-in authorization and caching
- 8x more performant than hand-rolled APIs