PowerShell script to run psql prompting for connection details

run-psql.ps1

Write-Host "Enter connection details:"

$server = "localhost"
$server_maybe = (Read-Host -Prompt "Server [$server]")
If($server_maybe -ne "") {
	$server = $server_maybe
}

$db = "postgres"
$db_maybe = (Read-Host -Prompt "Database [$db]")
If($db_maybe -ne "") {
	$db = $db_maybe
}

$port = 5432
[int]$port_maybe = (Read-Host -Prompt "Port [$port]")
If($port_maybe -ne "") {
	$port = $port_maybe
}

$username = "postgres"
$username_maybe = (Read-Host -Prompt "Username [$username]")
If($username_maybe -ne "") {
	$username = $username_maybe
}

Write-Host "Running psql"
Write-Host

psql -h $server -U $username -d $db -p $port

Thank you for your list of commands.

It works!
but it opens postgres=# terminal on powershell.
I want to write commands like create database, create table, etc. in the PowerShell file, so they can be executed automatically. Any ideas how?

According to man psql it's the -c command line option.

Thank you for your comment.

Yes, how how can I write those commands in Powershell?
After executing your commands, it just opens up the Postgres terminal. After successful login, I want commands to execute automatically.
Any Idea how to write it in powershell?
Thanks in advance.

Add -c 'your command' to the end of the last line.