From: | Michael Meskes <michael_meskes(at)topmail(dot)de> |
---|---|
To: | PgSQL Interfaces <pgsql-interfaces(at)postgreSQL(dot)org> |
Subject: | Re: [INTERFACES] ECPG & 'exec sql connect to' question |
Date: | 1999-03-05 14:49:45 |
Message-ID: | 19990305154945.A11186@gmx.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-interfaces |
On Thu, Mar 04, 1999 at 05:01:05PM +0100, Pavel PaJaSoft Janousek wrote:
> 'exec sql connect to unix:postgresql://localhost:5432/mm; '
>
> I thought, that this example is for ECPG, but....
It is. However, the same dbname syntax applies to all programs using libpq.
> All described this I make by psql monitor... I create database 'test'. Database 'test' is created by unix user 'paja' ('paja' is postgres user too). I create new postgres user 'petr' with password 'petr'. As 'paja', I connect to database 'test' and create table 'pom' with some cols, then execute this: 'grant insert on pom to petr;'. All is OK, but now, I want connect to database 'test' by user 'petr'... of course, I cant' use simple command:
> 'exec sql connect 'test';', because I want have only rights as user 'petr' (only inserting rows).
> My problem is, that I don't know, how I can connect to database (on
> local system or remote...) with specifiing user and his password. I
> know, that I can use libpq directly, but I want do this by ECPG, not
> by using the PostgreSQL C library.
the syntax is 'exec sql <dbname> user <username> identified by <password>'
> PS: A wrote this question in november 1998, but I didn't got some answer.
> Of course, I specify my question rather diferent...
Seems I missed it. Sorry.
Michael
--
Michael Meskes | Go SF 49ers!
Th.-Heuss-Str. 61, D-41812 Erkelenz | Go Rhein Fire!
Tel.: (+49) 2431/72651 | Use Debian GNU/Linux!
Email: Michael(dot)Meskes(at)gmx(dot)net | Use PostgreSQL!
From | Date | Subject | |
---|---|---|---|
Next Message | Oleg Broytmann | 1999-03-05 15:42:12 | Greek locale |
Previous Message | Byron Nikolaidis | 1999-03-05 14:28:01 | Re: [GENERAL] RV: Problems with Visual Fox |
From | Date | Subject | |
---|---|---|---|
Next Message | Bartek Teodorczyk | 1999-03-05 16:03:43 | Counting updates with libpq |
Previous Message | Sergio | 1999-03-05 09:31:32 | row count |