4 ms·

Not to diss the author or chime in with the umpteenth "this is easy why did you spend time on this"... A postgres db can query from external files as well. See

Not to diss the author or chime in with the umpteenth "this is easy why did you spend time on this"... A postgres db can query from external files as well. See: https://www.postgresql.org/docs/13/file-fdw.html https://www.postgresql.org/docs/13/file-fdw.html

LegitShady 5y ago
The major difference is seemingly that one is a database installation and the other is just a command line tool. What if I don’t have a Postgres DB, but I have some tabular data in a csv I want to query? Should I set up a database to query a file? I’m not sure why I would set up a database to run a query on a file when I can do it from the command line.
- zokier 5y ago
  Well, running postgres doesn't really need to be much more than `docker run --rm -v $PWD:/data -e POSTGRES_HOST_AUTH_METHOD=trust postgres`. While docker might have its downsides, it is convenient for this sort of ad-hoc stuff.