Login
Remember
Register
Questions
Unanswered
Tags
Categories
Ask a Question
Ask a Question
How to import data to PostgreSQL from *.sql files
+3
votes
asked
Feb 26, 2016
in
Databases
by
praveen
(
18.6k
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
0
votes
answered
Feb 26, 2016
by
praveen
(
18.6k
points)
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
(
15.4k
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
(
15.4k
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
(
18.6k
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
(
18.6k
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
(
18.6k
points)
sql
postgresql
count
distinct
Categories
All categories
Programming Languages
(563)
Machine Learning
(30)
Operating Systems
(100)
Databases
(62)
Web & Google
(69)
CMS Tips
(22)
General IT Tips
(40)
GK Quiz QA
(22)
Most popular tags
python
list
array
numpy
dataframe
pandas
linux
r
ubuntu
php
string
file
command
dictionary
postgresql
csr_matrix
apache
bing quiz
mysql
vps
directory
matrix
sort
vector
column
...