Ask a Question

How to import data to PostgreSQL from *.sql files

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

1 Answer

0 votes
by (11.1k points)

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 (3.7k points)
+3 votes
1 answer
PostgreSQL: How to export SQL result to a text file/CSV file
asked Mar 17, 2016 in Databases by praveen (11.1k points)
+2 votes
1 answer
How to count distinct rows in PostgreSQL table faster?
asked Jun 11, 2018 in Databases by praveen (11.1k points)
+2 votes
1 answer
How to export Postgres SELECT Query to CSV or text file?
asked Jun 19, 2018 in Databases by praveen (11.1k points)
Snow Theme by Q2A Market
Powered by Question2Answer
...