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
(
71.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
(
71.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
(
56.5k
points)
mysql
sql
import
+3
votes
1
answer
PostgreSQL : How to check the execution time of SQL queries?
asked
Jul 24, 2018
in
Databases
by
phpuser
(
56.5k
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
(
71.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
(
71.8k
points)
sql
union
postgresql
+2
votes
1
answer
How to count distinct rows in PostgreSQL table faster?
asked
Jun 11, 2018
in
Databases
by
praveen
(
71.8k
points)
sql
postgresql
count
distinct
Categories
All categories
Programming Languages
(719)
Machine Learning
(34)
Operating Systems
(122)
Databases
(92)
Web & Google
(88)
CMS Tips
(33)
General IT Tips
(82)
GK Quiz QA
(81)
...