Hey you can Import Files on a Terminal with sudo -u postgres psql < File.txt
Salima Begum schrieb am Mo., 18. Mai 2020,
13:50:
> Hi ,
> Mysql query which we used previously now we moved to postgresql,
> Here is the below query in mysql , Can anyone help me to write
> similar query in postgresql.
Hello Salima,
You could use the COPY command that is documented here.
https://www.postgresql.org/docs/current/static/sql-copy.html
But if the data is bulk and that data has to be copied or inserted into the
table in a faster manner, your ideal solution is *Pgloader *because of its
performance be
Hi ,
Mysql query which we used previously now we moved to postgresql,
Here is the below query in mysql , Can anyone help me to write
similar query in postgresql.
query = "LOAD DATA LOCAL INFILE '41098_category_list.txt' INTO TABLE
pages_rim_ls_categories FIELDS TERMINATED BY '|' LINES TERMINATED B
3 matches
Mail list logo
