PowerShell connect to Postgres DB

Question

Can you please advise whether there's a way how to connect to Postgres SQL DB from PowerShell WITHOUT installing any DB driver? I'm looking for solution which would be able to connect using only .NET database capabilities. Thanks.

Matthew

Community · Accepted Answer · 2017-05-23 12:07:38Z

9

With no client driver at all, you can simply execute the psql command-line then read and process its output. This is particularly useful when invoking it as psql -qAt and/or using \copy.

Otherwise you must have some kind of client driver. Powershell has no built-in support code for the PostgreSQL protocol, so it therefore cannot communicate with PostgreSQL without some kind of client driver. nPgSQL would be the most obvious choice since it integrates well in .NET and is composed only of .NET assemblies. You could probably bundle nPgSQL up as a Powershell extension... but as usual, someone already did that.

Otherwise you probably want to install psqlODBC, which is a simple msiexec to install then usable using the usual ODBC support.

(The only reason Powershell can talk to MS SQL without installing additional drivers is that drivers for MS SQL are built in).

edited May 23, 2017 at 12:07

CommunityBot

11 silver badge

answered May 26, 2015 at 11:31

Craig Ringer

329k83 gold badges742 silver badges820 bronze badges

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

2 Comments

Martinecko Over a year ago

What I'm trying to achieve is simply to verify user/password to access database. All I need to know is whether user is able to connect to DB. But I need to do this automatically via PowerShell. Any ideas?

Ben Collins Over a year ago

I think I would recommend Npgsql over ODBC.

Collectives™ on Stack Overflow

PowerShell connect to Postgres DB

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest