How to import external sql scripts from a sql script in PostgreSQL?

Question

I was wondering if it is possible/how to include one .sql file in another .sql file, as is done in other programming languages like C or Java?

I am asking because I wanted to organize my sql scripts into support library files and application scripts, and so on. I searched around, and solutions seem to be about loading .sql files from the psql client (see e.g. postgreSQL - psql \i : how to execute script in a given path). What I am interested in is to load a library .sql script from inside a sql script.

P.S. I am using PL/pgSQL (PostgreSQL 9.3).

Provide an SSCCE to clarify your objective. Show the code you are trying the nest, even if it's not working. — Erwin Brandstetter
– Erwin Brandstetter, Commented Jan 9, 2015 at 7:41

Community · Accepted Answer · 2017-05-23 12:26:42Z

2

Based on the answer It is possible to reference another SQL file from SQL script, on PostgreSQL, you can include another SQL's files just using the \i syntax. I just tested and is working good on PostgreSQL 9.6:

\i other_script.sql
SELECT * FROM table_1;
SELECT * FROM table_2;

edited May 23, 2017 at 12:26

CommunityBot

11 silver badge

answered Nov 18, 2016 at 1:33

Evandro Coan

9,66115 gold badges103 silver badges163 bronze badges

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

Collectives™ on Stack Overflow

How to import external sql scripts from a sql script in PostgreSQL?

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related