5/21/2023 0 Comments Postico documentationStep 3: Change the table name in the Output Options section where it says “Schema.Table or View Name:” to “geotargets”.Step 2: Select the “Choose File” tab to upload a CSV file.Why? Because the file is big enough that it would probably run pretty slowly in a spreadsheet tool. There are lots of ways to populate data into a database but again, this is an MVP.įor this tutorial, I’m using the Google Analytics Geo Targets CSV list found here. The imaginatively named, generates the SQL commands to populate tables based on a CSV file’s contents. There are tools out there that will shortcut that process for us too. You might not yet know how to run CREATE TABLE commands but that’s ok. You have to tell the database exactly how each table should be structured and then what data should be added to each table. Loading tables in Postgres is a little bit different (aka more involved) than loading a CSV into Google Sheets or Excel. ![]() Next, let’s load some actual data into Postgres. Ok, the boring stuff is out of the way and it’s only been about 15 minutes! Now we can get to the actual analysis. You’ve done it! You’ve started up a Postgres database, connected to it, and run your first query! Loading data into Postgres Since you haven’t loaded any tables, you’ll just see a list of Postgres system tables that start with the prefix, “ pg_.” As you probably guessed, the “ pg” stands for Postgres. Run the query “ select * from pg_tables ” to see a list of all the tables in your Postgres database.
0 Comments
Leave a Reply. |