11 ms·
Relative paths are a must. I don't think I ever use non-relative paths. Say you have a folder structure like this: sql/ tables/ foo.sql
by koolba 10y ago
Relative paths are a must. I don't think I ever use non-relative paths.
Say you have a folder structure like this:
sql/
tables/
foo.sql
bar.sql
main.sql
And the contents of main.sql are something like this:
@@tables/foo.sql
@@tables/foo.sql
Then you can run main.sql via: usql -f sql/main.sql
If script file resolution is not relative pathed to the parent, it gets very fragile as you must invoke the parent from a specific location, or, you have to hard code full pathes in your scripts (arguably even uglier).
- kenshaw 10y agoThis is a feature in psql? I must admit if it is, I'm not familiar with it.
- koolba 10y agoYes psql supports it. The syntax is "\i path/to/file.sql" or "\ir relative/path/to/file.sql". The latter is resolved relative to the parent script. Makes nesting scripts possible without losing your sanity.
- kenshaw 10y agoYes, if it's in psql, I'll get it into usql in the near future. (for certain large values of near).
- ComodoHacker 10y agoThis feature is actually borrowed from Oracle's SQLPlus.