How to initialize multiple sql files with postgreSQL

Question

I am new to web dev and taking a run at a full-stack node, react, express, postgreSQL app. All of the tutorials I had done and documentation I have found thus far, talk about using a single .sql file. However I imagine you would use multiple in a large app?

For example, in a small version of a Facebook clone, I would think you would have a separate .sql for users, posts, groups, etc... It would seem an awful mess to lump everything into one file, lol.

If multiple files is the way to go I am wondering how to initiate those files. Do you still use one database name but use multiple sql files? The closest I have found is something like the following:

// Initiate your database in a bash script
database="appdb"

dropdb -U node_user appdb
createdb -U node_user appdb

// Initiate sql files, something like this?
psql -U node_user "BEGIN;" \i file1.sql \i file2.sql "COMMIT;"

// Or iterate through the .sql files?
for file in dir/*.sql
    do sudo -u postgres psql $DATABASE_NAME -f $file
done

Wondering if either of those is correct and if there is a standard way of doing this. Any thoughts and/or further reading material is appreciated.

Thanks much

Laurenz Albe · Accepted Answer · 2021-05-21 02:50:12Z

6

If you want to run several scripts in a single transaction, use

psql -U node_user -d "$database" --single-transaction -f file1.sql -f file2.sql

answered May 21, 2021 at 2:50

Laurenz Albe

257k22 gold badges312 silver badges388 bronze badges

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

Collectives™ on Stack Overflow

How to initialize multiple sql files with postgreSQL

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