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
(
15.3k
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
(
15.3k
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
(
6.8k
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
(
6.8k
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
(
15.3k
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
(
15.3k
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
(
15.3k
points)
sql
postgresql
count
distinct
Categories
All categories
General
(35)
CMS Tips
(12)
Operating Systems
(78)
Web & Google
(59)
Programming Languages
(363)
Databases
(59)
Most popular tags
python
list
numpy
array
linux
ubuntu
pandas
php
file
dataframe
string
dictionary
postgresql
command
apache
mysql
csr_matrix
directory
csv
vps
windows
sql
nginx
matrix
typeerror
...
