Re: Recursive Arrays 101

From: John R Pierce <pierce(at)hogranch(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Recursive Arrays 101
Date: 2015-10-26 23:26:10
Message-ID: 562EB692.3020906@hogranch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 10/26/2015 4:22 PM, Gavin Flower wrote:
>
> By type of shell, is meant are using a bash shell in your terminal, or
> csh, or something else? Bash stands for BOurne Again Shell, it process
> commands like 'psql' that you type into the shell.
>
> Please copy i the email addresses of the other helping you & the
> mailing list!

he said some time ago, he's running MS Windows, with EnterpriseDB's
installation package of PostgreSQL. 'SQL Shell' is a Start Menu
item/shortcut that references a batch script,
D:\PostgreSQL\9.3\scripts\runpsql.bat which in turn looks like...

@echo off
REM Copyright (c) 2012-2014, EnterpriseDB Corporation. All rights reserved

REM PostgreSQL server psql runner script for Windows

SET server=localhost
SET /P server="Server [%server%]: "

SET database=postgres
SET /P database="Database [%database%]: "

SET port=5432
SET /P port="Port [%port%]: "

SET username=postgres
SET /P username="Username [%username%]: "

for /f "delims=" %%a in ('chcp ^|find /c "932"') do @ SET
CLIENTENCODING_JP=%%a
if "%CLIENTENCODING_JP%"=="1" SET PGCLIENTENCODING=SJIS
if "%CLIENTENCODING_JP%"=="1" SET /P PGCLIENTENCODING="Client Encoding
[%PGCLIENTENCODING%]: "

REM Run psql
"D:\PostgreSQL\9.3\bin\psql.exe" -h %server% -U %username% -d %database%
-p %port%

pause

--
john r pierce, recycling bits in santa cruz

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message David Blomstrom 2015-10-26 23:27:14 Re: Recursive Arrays 101
Previous Message Gavin Flower 2015-10-26 23:22:14 Re: Recursive Arrays 101