-- -- Create a Test Schema -- create schema testschema; -- -- Create a Test Sequence -- CREATE SEQUENCE testschema.my_test_seq; -- -- Create a Test Table -- CREATE TABLE testschema.testtable( test_id INTEGER PRIMARY KEY DEFAULT NEXTVAL('testschema.my_test_seq'), test_name VARCHAR(50), test_email VARCHAR(50) ); -- -- Insert some data into the test table -- INSERT INTO testschema.testtable (test_name, test_email) VALUES('Murial Spark', 'murial@comforters.com'); INSERT INTO testschema.testtable (test_name, test_email) VALUES('Samuel Beckett', 'sam@godot.com'); INSERT INTO testschema.testtable (test_name, test_email) VALUES('William Gaddis', 'bill@jr.com'); -- -- Select * from test table -- select * from testschema.testtable -- -- All done --