Problem scenario
You want to extract data from a .csv file.  In other words you want to  transform data from a flat file and import it into a database.  Is there an example of how to create a table, format a .csv file, and run a command to import the .csv file into the Postgresql database?

Solution
1.  Here is how to create a table to target for the import or ETL (Extract,

…

Continue reading “How Do You Ingest (or Import) a CSV File into a Postgresql Database Table?”

Problem scenario
You want to create two tables in a Postgresql database.  You want the tables to share a column to relate to one another.  You want to implement a foreign key constraint to achieve this goal.  Is there an example of SQL statements to do this?

Solution
Run these two SQL commands that start with the words “CREATE TABLE”:

CREATE TABLE table1 (id integer,

…

Continue reading “How Do You Create Two Tables with a Shared Column between Them (e.g., Have a Foreign Key Constraint)?”

Problem scenario
You are trying to create a table using SQL.  You use the keywords “CONSTRAINT” and “PRIMARY KEY.”  For example, your query (or SQL DML command) looks like this:

create table contint ( specialcode char(6) CONSTRAINT PRIMARY KEY, title varchar(40)) ;

When you run the SQL command you get the message ‘…syntax error at or near “PRIMARY” LINE…’  What should you do to fix this?

…

Continue reading “How Do You Troubleshoot a Syntax Error When Trying to Create a Table with a Primary Key in SQL?”