How to execute *.sql file using psql

postgresql psql
Vivek S. picture Vivek S. · Jun 2, 2014 · Viewed 37k times · Source

I have created an index.sql file which contains index creating script for 95 table

for example

DROP INDEX IF EXISTS gtab03_vrctrlid_idx cascade;
CREATE UNIQUE INDEX gtab03_vrctrlid_idx ON gtab03 USING btree (vrctrlid);

I have consolidated all table's index creating script to a file called index.sql I need to run the entire script at a time, is it possible to execute the index.sql file using psql

Answer

Sney picture Sney · Jun 2, 2014

Is that what u mean?

\i e:/myFolder/index.sql;

Related questions

PostgreSQL "DESCRIBE TABLE"

How do you perform the equivalent of Oracle's DESCRIBE TABLE in PostgreSQL (using the psql command)?

Read More
Run a PostgreSQL .sql file using command line arguments

I have some .sql files with thousands of INSERT statements in them and need to run these inserts on my PostgreSQL database in order to add them to a table. The files are that large that it is impossible to …

Read More
How to switch databases in psql?

In MySQL, I used use database_name; What's the psql equivalent?

Read More