Login
Remember
Register
Questions
Unanswered
Categories
Ask a Question
Quiz
Ask a Question
How to import data to PostgreSQL from *.sql files
+3
votes
asked
Feb 26, 2016
in
Databases
by
praveen
(
74.8k
points)
I want to import data from .sql files to PostgreSQL, how can I do that?
postgresql
sql
import
Please
log in
or
register
to add a comment.
Please
log in
or
register
to answer this question.
1
Answer
+1
vote
answered
Feb 26, 2016
by
praveen
(
74.8k
points)
selected
Mar 2, 2023
by
praveen
Best answer
If you have logged on postgreSQL, type the following command to import data.
\
i
filename
.
sql
Please
log in
or
register
to add a comment.
Related questions
+3
votes
1
answer
MySQL: how to import data from an SQL file to a database using the command line
asked
Jan 13, 2020
in
Databases
by
phpuser
(
66.7k
points)
mysql
sql
import
+1
vote
1
answer
PostgreSQL: how to write WHERE clause in SQL using regular expression
asked
Jul 5, 2025
in
Databases
by
phpuser
(
66.7k
points)
sql
postgresql
+3
votes
1
answer
PostgreSQL : How to check the execution time of SQL queries?
asked
Jul 24, 2018
in
Databases
by
phpuser
(
66.7k
points)
postgresql
sql
time
+3
votes
1
answer
PostgreSQL: How to export SQL result to a text file/CSV file
asked
Mar 16, 2016
in
Databases
by
praveen
(
74.8k
points)
csv
postgresql
sql
output
+2
votes
1
answer
PostgreSQL: how to keep duplicate records in the query result of UNION operator
asked
Jul 2, 2019
in
Databases
by
praveen
(
74.8k
points)
sql
union
postgresql
Categories
All categories
Programming Languages
(751)
Machine Learning
(37)
Operating Systems
(155)
Databases
(109)
Web & Google
(93)
CMS Tips
(41)
General IT Tips
(99)
GK Quiz QA
(81)
...
