How to import data from a text file into a specific PostgreSQL column?

Question

I have a text file which contains val1

And my table in PostgesSql is in format

val1 | val2 | val3 | ...

Edited : When I tried writing the command from here, Following error is shown.

Thanks in advance.

An error is thrown. I edited the post and it is elaborated their. — Khondoker I. Islam
– Khondoker I. Islam, Commented Feb 16, 2020 at 15:29
What do you not understand about relation "mytable" does not exist ? It does mean that you will have to create the table in postgresql yourself, before trying to import data. — Luuk
– Luuk, Commented Feb 16, 2020 at 15:34
After that, I can then write this command and follow that link? — Khondoker I. Islam
– Khondoker I. Islam, Commented Feb 16, 2020 at 15:48
Maybe look at this link, it works better: stackoverflow.com/questions/60250167/… (only change tablename, and you use different delimiter...) — Luuk
– Luuk, Commented Feb 16, 2020 at 15:54

Khondoker I. Islam · Accepted Answer · 2020-04-18 14:11:23Z

0

There is a drop option in a table, there import the .txt file in the drop-down options with corresponding column name. Later refresh the table, then view it. Walah, you got table exactly as your .txt file. Thank You.

answered Apr 18, 2020 at 14:11

Khondoker I. Islam

417 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to import data from a text file into a specific PostgreSQL column?

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related