Sfrgttk

Force user to remove USB token

Why does Captain Marvel assume the people on this planet know this?

What does a stand alone "T" index value do?

Making a sword in the stone, in a medieval world without magic

Look through the portal of every day

Extra alignment tab has been changed to cr. } using table, tabular and resizebox

Why would a jet engine that runs at temps excess of 2000°C burn when it crashes?

Is there any way to damage Intellect Devourer(s) when already within a creature's skull?

Reverse string, can I make it faster?

How did Alan Turing break the enigma code using the hint given by the lady in the bar?

Should QA ask requirements to developers?

Good allowance savings plan?

Make a transparent 448*448 image

Unreachable code, but reachable with exception

Is Gradient Descent central to every optimizer?

How much stiffer are 23c tires over 28c?

Aliens englobed the Solar System: will we notice?

How could our ancestors have domesticated a solitary predator?

Does splitting a potentially monolithic application into several smaller ones help prevent bugs?

Do items de-spawn in Diablo?

Is having access to past exams cheating and, if yes, could it be proven just by a good grade?

In the late 1940’s to early 1950’s what technology was available that could melt a LOT of ice?

Accountant/ lawyer will not return my call

Placing subfig vertically

Why am I getting table does not exist error?

0

so I'm trying to creating a database table using pg admin. I created a table in pg admin and then I was supposed to run the table using putty. But when I run it it says error table does not exist. The table does exist though so I don't know why I'm getting that error!

--Dropping tables clear out any existing data

DROP TABLE IF EXISTS automobiles;



CREATE TABLE automobiles(

    id INTEGER PRIMARY KEY,

    make VARCHAR(15)NOT NULL,

    model VARCHAR(20)NOT NULL,

    year INTEGER NOT NULL,

    owner CHAR(25) NOT NULL,

    msrp DECIMAL NOT NULL,

    purchase_date DATE NOT NULL

);







INSERT INTO automobiles(id, make, model, year, owner, msrp, purchase_date) VALUES(

    1,

    'Ferarri',

    'F40',

    '1987',

    '',

    '1690000',

    '3/12/2019');

INSERT INTO automobiles(id, make, model, year,owner, msrp, purchase_date)VALUES(

    2,

    'Tundra',

    '4X2',

    '2019',

    '',

    '39625',

    '3/12/2019');

INSERT INTO automobiles(id, make, model, year,owner, msrp, purchase_date) VALUES(

    3,

    'Mercedes-Benz',

    'AMG GT',

    '2014',

    '',

    '145000',

    '3/12/2019');

INSERT INTO automobiles(id, make, model, year,owner, msrp, purchase_date)VALUES(

    4,

    'Chrysler',

    '300',

    '2004',

    '',

    '800',

    '3/12/2019');

INSERT INTO automobiles(id, make, model, year,owner, msrp, purchase_date) VALUES(

    5,

    'Jeep',

    'Wrangler',

    '2019',

    '',

    '33695',

    '3/12/2019');



SELECT make, model, year, msrp FROM automobiles ORDER BY year ASC;



UPDATE automobiles

SET owner = 'Deanna Slotegraaf'

WHERE make = 'ferarri';



DELETE FROM automobiles WHERE make = 'Chrysler';

This is the full set of code that I have.

Thanks...

postgresql pgadmin

share

asked 4 mins ago

Dee SlotegraafDee Slotegraaf

1

New contributor

Dee Slotegraaf is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

add a comment | 

0

so I'm trying to creating a database table using pg admin. I created a table in pg admin and then I was supposed to run the table using putty. But when I run it it says error table does not exist. The table does exist though so I don't know why I'm getting that error!

--Dropping tables clear out any existing data

DROP TABLE IF EXISTS automobiles;



CREATE TABLE automobiles(

    id INTEGER PRIMARY KEY,

    make VARCHAR(15)NOT NULL,

    model VARCHAR(20)NOT NULL,

    year INTEGER NOT NULL,

    owner CHAR(25) NOT NULL,

    msrp DECIMAL NOT NULL,

    purchase_date DATE NOT NULL

);







INSERT INTO automobiles(id, make, model, year, owner, msrp, purchase_date) VALUES(

    1,

    'Ferarri',

    'F40',

    '1987',

    '',

    '1690000',

    '3/12/2019');

INSERT INTO automobiles(id, make, model, year,owner, msrp, purchase_date)VALUES(

    2,

    'Tundra',

    '4X2',

    '2019',

    '',

    '39625',

    '3/12/2019');

INSERT INTO automobiles(id, make, model, year,owner, msrp, purchase_date) VALUES(

    3,

    'Mercedes-Benz',

    'AMG GT',

    '2014',

    '',

    '145000',

    '3/12/2019');

INSERT INTO automobiles(id, make, model, year,owner, msrp, purchase_date)VALUES(

    4,

    'Chrysler',

    '300',

    '2004',

    '',

    '800',

    '3/12/2019');

INSERT INTO automobiles(id, make, model, year,owner, msrp, purchase_date) VALUES(

    5,

    'Jeep',

    'Wrangler',

    '2019',

    '',

    '33695',

    '3/12/2019');



SELECT make, model, year, msrp FROM automobiles ORDER BY year ASC;



UPDATE automobiles

SET owner = 'Deanna Slotegraaf'

WHERE make = 'ferarri';



DELETE FROM automobiles WHERE make = 'Chrysler';

This is the full set of code that I have.

Thanks...

postgresql pgadmin

share

asked 4 mins ago

Dee SlotegraafDee Slotegraaf

1

New contributor

Dee Slotegraaf is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

add a comment | 

so I'm trying to creating a database table using pg admin. I created a table in pg admin and then I was supposed to run the table using putty. But when I run it it says error table does not exist. The table does exist though so I don't know why I'm getting that error!

--Dropping tables clear out any existing data

DROP TABLE IF EXISTS automobiles;



CREATE TABLE automobiles(

    id INTEGER PRIMARY KEY,

    make VARCHAR(15)NOT NULL,

    model VARCHAR(20)NOT NULL,

    year INTEGER NOT NULL,

    owner CHAR(25) NOT NULL,

    msrp DECIMAL NOT NULL,

    purchase_date DATE NOT NULL

);







INSERT INTO automobiles(id, make, model, year, owner, msrp, purchase_date) VALUES(

    1,

    'Ferarri',

    'F40',

    '1987',

    '',

    '1690000',

    '3/12/2019');

INSERT INTO automobiles(id, make, model, year,owner, msrp, purchase_date)VALUES(

    2,

    'Tundra',

    '4X2',

    '2019',

    '',

    '39625',

    '3/12/2019');

INSERT INTO automobiles(id, make, model, year,owner, msrp, purchase_date) VALUES(

    3,

    'Mercedes-Benz',

    'AMG GT',

    '2014',

    '',

    '145000',

    '3/12/2019');

INSERT INTO automobiles(id, make, model, year,owner, msrp, purchase_date)VALUES(

    4,

    'Chrysler',

    '300',

    '2004',

    '',

    '800',

    '3/12/2019');

INSERT INTO automobiles(id, make, model, year,owner, msrp, purchase_date) VALUES(

    5,

    'Jeep',

    'Wrangler',

    '2019',

    '',

    '33695',

    '3/12/2019');



SELECT make, model, year, msrp FROM automobiles ORDER BY year ASC;



UPDATE automobiles

SET owner = 'Deanna Slotegraaf'

WHERE make = 'ferarri';



DELETE FROM automobiles WHERE make = 'Chrysler';

This is the full set of code that I have.

Thanks...

postgresql pgadmin

share

asked 4 mins ago

Dee SlotegraafDee Slotegraaf

1

New contributor

Dee Slotegraaf is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

--Dropping tables clear out any existing data

DROP TABLE IF EXISTS automobiles;



CREATE TABLE automobiles(

    id INTEGER PRIMARY KEY,

    make VARCHAR(15)NOT NULL,

    model VARCHAR(20)NOT NULL,

    year INTEGER NOT NULL,

    owner CHAR(25) NOT NULL,

    msrp DECIMAL NOT NULL,

    purchase_date DATE NOT NULL

);







INSERT INTO automobiles(id, make, model, year, owner, msrp, purchase_date) VALUES(

    1,

    'Ferarri',

    'F40',

    '1987',

    '',

    '1690000',

    '3/12/2019');

INSERT INTO automobiles(id, make, model, year,owner, msrp, purchase_date)VALUES(

    2,

    'Tundra',

    '4X2',

    '2019',

    '',

    '39625',

    '3/12/2019');

INSERT INTO automobiles(id, make, model, year,owner, msrp, purchase_date) VALUES(

    3,

    'Mercedes-Benz',

    'AMG GT',

    '2014',

    '',

    '145000',

    '3/12/2019');

INSERT INTO automobiles(id, make, model, year,owner, msrp, purchase_date)VALUES(

    4,

    'Chrysler',

    '300',

    '2004',

    '',

    '800',

    '3/12/2019');

INSERT INTO automobiles(id, make, model, year,owner, msrp, purchase_date) VALUES(

    5,

    'Jeep',

    'Wrangler',

    '2019',

    '',

    '33695',

    '3/12/2019');



SELECT make, model, year, msrp FROM automobiles ORDER BY year ASC;



UPDATE automobiles

SET owner = 'Deanna Slotegraaf'

WHERE make = 'ferarri';



DELETE FROM automobiles WHERE make = 'Chrysler';

share

asked 4 mins ago

Dee SlotegraafDee Slotegraaf

1

New contributor

Dee Slotegraaf is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

share

asked 4 mins ago

Dee SlotegraafDee Slotegraaf

1

New contributor

Dee Slotegraaf is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

asked 4 mins ago

Dee SlotegraafDee Slotegraaf

1

New contributor

Dee Slotegraaf is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

asked 4 mins ago

Dee SlotegraafDee Slotegraaf

1