Search Postgresql Archives

Re: SQL Path in psql

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Fri, Sep 06, 2013 at 10:45:26AM -0700, David Johnston wrote:
- lup wrote
- >>
- >>
- > I wonder if this would at least get the full path on-screen for a c/p
- >      \! for d in  $SQLPATH; do find $d -name 
- > <script-filename>
- > ; done
- > 
- > That said, I would down-vote this suggestion.  I tend to put sql files 
- > in amongst my various project dirs and maintaining the envvar isn't 
- > worth it.
- > 
- > Anything I re-use I make into a function.
- 
- Usually a down-vote there is something that can go wrong if the feature is
- implemented.  Simply not personally having a use for said feature normally
- results in a "+0" vote or something similar.
- 
- The big issue with environment variables is their ability to have resolution
- conflicts. I think the general idea has merit though setting symbolic-links
- (in Linux variants at least) can get you some of the way there in a less
- error-prone (but more verbose) way.
- 
- Ultimately feature requests get made to here then end up on the ToDo listing
- if the idea has traction.
- 
- David J.

I suspect this feature makes more sense on a windows platform. On linux where we can
go psql -f ${SQLPATH}/file.sql . it becomes less pressing. Even Oracle
on unix/linux where you can go sqlplus <<EOD @${SQLPATH}/file.sql EOD. makes
it less a requirement. 

on the other hand, does seems like a pretty easy thing to implement.


-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general




[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux