Q:

Write a postgre SQL statement to create a table named jobs, including job_id, job_title, min_salary and max_salary,

hamza
Save to bookmark
|
2022-05-18
|
  111 
0

Write a SQL statement to create a table named jobs, including job_id, job_title, min_salary and max_salary, and make sure that, the default value for job_title is blank and min_salary is 8000 and max_salary is NULL will be entered automatically at the time of insertion if no value assigned for the specified columns.

Postgre SQL,
login and add your own answer to this question

All Answers

hamza
2022-05-18
need an explanation for this answer? contact us directly to get an explanation for this answer 

CREATE TABLE IF NOT EXISTS jobs ( 
JOB_ID varchar(10) NOT NULL UNIQUE, 
JOB_TITLE varchar(35) NOT NULL DEFAULT ' ', 
MIN_SALARY decimal(6,0) DEFAULT 8000, 
MAX_SALARY decimal(6,0) DEFAULT NULL
);

Output:

postgres=# CREATE TABLE IF NOT EXISTS jobs (
postgres(# JOB_ID varchar(10) NOT NULL UNIQUE,
postgres(# JOB_TITLE varchar(35) NOT NULL DEFAULT ' ',
postgres(# MIN_SALARY decimal(6,0) DEFAULT 8000,
postgres(# MAX_SALARY decimal(6,0) DEFAULT NULL
postgres(# );
CREATE TABLE

Here is the command to see the structure of the created table :

postgres=# \d jobs
                            Table "public.jobs"
   Column   |         Type          |                Modifiers
------------+-----------------------+-----------------------------------------
 job_id     | character varying(10) | not null
 job_title  | character varying(35) | not null default ' '::character varying
 min_salary | numeric(6,0)          | default 8000
 max_salary | numeric(6,0)          | default NULL::numeric
Indexes:
    "jobs_job_id_key" UNIQUE CONSTRAINT, btree (job_id)

need an explanation for this answer? contact us directly to get an explanation for this answer

total answers (1)

Similar questions

need a help?

find thousands of online teachers now