Thanks all. I'd tried pgadmin3 and perhaps moved on too quickly. On
2nd look it's better than I'd initially considered.
Cheers,
Scott
On Wed, Oct 19, 2011 at 1:13 AM, Basil Bourque wrote:
>>> I have a postgres 9.1 database up & running, no problem. Purely in
>>> terms of writing sql (ddl, dml &
I have references to dblink. I just installed 9.1.1.1 on windows server
2008 R2 and did a search on the file dblink.sql and cannot find it. I used
the one click installer from enterprisedb.
1. Where is the dblink.sql file or does it not exist anymore and the
integration into postgresql has chan
Hi.
If you have 9.1, then exist foreign wrapper odbc_fdw, you may try it.
2011/10/19, Rich :
>>
>> I have a mumps database with an ODBC connection so I can write queries
>> from
>> this database. How can I write a sql in Postgresql to access this
>> database
>> to use in my Postgresql reports?
>
On Wed, Oct 19, 2011 at 9:19 AM, Rich wrote:
>> I have a mumps database with an ODBC connection so I can write queries
>> from this database. How can I write a sql in Postgresql to access this
>> database to use in my Postgresql reports?
dblink lets one pg server access another via SQL, dbilink
>
> I have a mumps database with an ODBC connection so I can write queries from
> this database. How can I write a sql in Postgresql to access this database
> to use in my Postgresql reports?
>
Thanks very much. I replaced my statement by the following plpgsql code :
statement := 'DROP ROLE "'||(SELECT ...)||'";';
execute(statement);
and it works like a charm.
Regards,
Brice
2011/10/19 Andreas Kretschmer
> You can't do that in THAT way, but you can use dynamic SQL:
>
> test=# select
On Wed, 2011-10-19 at 12:11 +0200, Brice André wrote:
> Hello everyone,
>
> I would want to implement an SQL query where I would be able to suppress all
> information from a registered user. I am currenlty able to suppress
> everything except the user role. The name of the role is present in a tab
Hello everyone,
I would want to implement an SQL query where I would be able to suppress all
information from a registered user. I am currenlty able to suppress
everything except the user role. The name of the role is present in a table
and so, I would want to perform something like this :
DROP RO
>> I have a postgres 9.1 database up & running, no problem. Purely in
>> terms of writing sql (ddl, dml & pg/plsql), what tools are
>> recommended?
>>
>> Coming from an Oracle world, I'm thinking of toad, sql developer, etc.
>>
>> 1. psql & text editor of choice (if so, which one?)
>> 2. navicat
