Import Data of Excel/CSV file into PostgreSQL Database.

#SQL
#PLSQL
#Oracle
#ORACLEAPPS
#OracelFusion
#TechTalkswithNaresh
#Naresh
#R12
#EBSConsultant

Join Our Telegram Group:

FOLLOW US :
============

For More details Contact Us:

--------------------------------------------------------------------------------------------------------------------------------------------------------

This Video will help full for them who are trying to Insert the huge data set of Excel file in to the PostgreSQL Database.

Steps:
1. We need .csv file.
2. We need to create the table structure.
3. Create the table.
4. Run the copy command.
5. Validate the data inserted in table by select query.

[mangeshkale]

I am trying to update from a long to load the data this had help Thanks

[jszymc]

Thanks for sharing this information! I have a follow up question. If I had 3 excel files with 1, 000, 000 rows each what would be the best way to get all three files into the same sql table?

[DJDuSitko]

How u create the file with column name? You wrote by hand? or you created in Excel or other programs?

[ajayidamola]

Hello Naresh, how did you manage to write out the columns header names in the your note pad I need to know about this

[evfpyyy]

Расскажи, пожалуйста, про формулы в PostgreSQL

[vickymishra]

How to connect postgresql database to excel office addin using excel JavaScript api

[funtime]

I have 1000 columns, Is there any way to import it directly??

[kavitanavria]

I am getting some error here. Plz explain
first row, first column is GULMARG so the error is

ERROR: malformed array literal: "GULMARG"
DETAIL: Array value must start with "{" or dimension information.
CONTEXT: COPY test_csv1, line 2, column satation_name: "GULMARG"
SQL state: 22P02