@ oracle equivalent in postgres

Question

How can i run multiple sql files from one main sql files in postgres.

For example in oracle Inside Main.sql i can specify n number of @Child.sql , and then i can run Main.sql to run all child.sql 's .

How can i do this in the postgres.

Thanks! Pratik

babbageclunk · Accepted Answer · 2009-11-19 13:08:52Z

3

\i is the psql equivalent of the Oracle SQL*Plus @ command.

If you're using psql to run the Main.sql script, you can put:

\i path/to/child.sql

... in Main.sql. The difference between this and the EXECUTE SCRIPT command pointed out by Tzury is that there the path in FILENAME would refer to a path on the server's file system, while the \i command refers to a path on the machine running psql.

answered Nov 19, 2009 at 13:08

babbageclunk

8,7911 gold badge36 silver badges37 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

@ oracle equivalent in postgres

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related