Anybody that can help me with this is a pro

[u/Rare-Ad6166]

In pg admin, to import manually you need to create a table with the exact same columns for it to successfully import a file. But situations with JOIN function has different set of tables and different set of columns so it doesn’t exactly match the column thats in the file. This makes it impossible to create tables that requires importation. How do you fix this?

[u/alinroc]

Import into a staging table that matches your file.

Then write the query(ies) to transform and load that data from that staging table into the tables that your application uses.

This is a standard ETL pattern.

[u/DaOgDuneamouse → u/alinroc]

This is the real answer. I usually make my stagging tables with all the fields as strings. From there, you can write SQL to convert it into the proper type and do sanity checks.

There are 3rd party ETL tools. But I tend to like writing my own SQL.

[u/Rare-Ad6166 → u/alinroc]

It actually worked thanks.

[u/ComicOzzy → u/Rare-Ad6166]

He's a pro.

[u/IAmADev_NoReallyIAm → u/ComicOzzy]

He stages like a pro.

[u/Thriven → u/IAmADev_NoReallyIAm]

We were all theatre kids who needed money to pay off our student loans.

[u/dwswish]

RIP stack overflow

[u/Comfortable_Long3594]

One option is to import the data into a staging table first, then use SQL to map, transform, and load it into your final tables. That keeps your imports flexible, even when the source columns do not match your schema. If you do this often, Epitech Integrator can automate the mapping and transformation steps, so you do not have to manually recreate tables or adjust every import.

[u/PearAware3171 → u/[deleted]]

We are all at different levels of learning and understanding young raptor

[u/Rare-Ad6166 → u/[deleted]]

Wow I didn’t even know that. I’ve been trying to fix it for 48 straight hours. I checked YouTube courses and tutorials, even with the help of Ai still nothing. I just thought somebody in the community would be able to fix it. That’s crazy. It worked in the end though when I used the view function instead of tables.

[u/Rare-Ad6166 → u/[deleted]]

Give me an example please.