postgres -

Tag: postgres

  • Connecting to postgres databases on remote Windows machines

    There are three things you need to do to connect to a postgres server on a different Windows machine. The first two are clearly documented, the third is assumed. However, depending on how your environment is configured, the third may be an utter pain of headbanging annoyance until you realise how simple it is. Also, […]

  • A way to avoid some carelessness with postgres

    Part of my day job involves loading data from lots of different files into a database, and one way this can go horribly wrong is if I attempt to load the same file twice. Either the database will get mad at me because I’ll be trying to violate referential integrity, or my end users will […]