Unanswered: Creating Tables and Data From Text Files
I've picked up a basic SQL book from Amazon to help me understand ANSI SQL. The book has a site where I'm suggested to download a sample database so that I may follow along and execute the explained lessons on. My problem is after I create the database:
CREATE DATABASE tysql OWNER carlos;
COMMENT ON DATABASE tysql IS 'Teach Yourself SQL';
Now I've downloaded the ZIP archive and extracted two files I've attached below which were specified for my particular RDBMS (PostgreSQL) that I'm using. My question is how to use the two files to CREATE my tables and INSERT my row data?
I agree and apologize. I assumed since it was a ANSI SQL book and the files were *.txt, it would be ANSI SQL statements to CREATE / UPDATE my new database. Now I realized the commands were specific to my DBMS client (psql).