Login
Remember
Register
Questions
Unanswered
Tags
Categories
Ask a Question
Blogs
Contact Us
Ask a Question
How to import data to PostgreSQL from *.sql files
+3
votes
asked
Feb 26, 2016
in
Databases
by
praveen
(
17.0k
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
(
17.0k
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
(
8.6k
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
(
8.6k
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
(
17.0k
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
(
17.0k
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
(
17.0k
points)
sql
postgresql
count
distinct
Categories
All categories
General
(37)
CMS Tips
(12)
Operating Systems
(87)
Web & Google
(60)
Programming Languages
(467)
Databases
(60)
Most popular tags
python
list
array
numpy
linux
ubuntu
php
r
string
pandas
dataframe
file
command
postgresql
csr_matrix
dictionary
apache
mysql
directory
vps
csv
sort
column
matrix
windows
...
