Ask a Question

How to import data to PostgreSQL from *.sql files

+3 votes
in Databases by (71.8k points)
I want to import data from .sql files to PostgreSQL, how can I do that?

1 Answer

+1 vote
by (71.8k points)
selected by
 
Best answer

If you have logged on postgreSQL, type the following command to import data.

\i filename.sql 

Related questions

+3 votes
1 answer
PostgreSQL : How to check the execution time of SQL queries?
asked Jul 24, 2018 in Databases by phpuser (56.8k points)
+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)
+2 votes
1 answer
How to count distinct rows in PostgreSQL table faster?
asked Jun 11, 2018 in Databases by praveen (71.8k points)

Categories

Powered by Question2Answer
...