Ask a Question

How to import data to PostgreSQL from *.sql files

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

1 Answer

0 votes
by (54.0k 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 (43.2k 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 (54.0k points)
+2 votes
1 answer
How to count distinct rows in PostgreSQL table faster?
asked Jun 11, 2018 in Databases by praveen (54.0k points)

Categories

Snow Theme by Q2A Market
Powered by Question2Answer
...