Re: [pgadmin-support] enhancement request: on Control-Copy please get correct quotes

2007-02-12 Thread Dave Page
Harald Armin Massa wrote: I am using fields of type "inet" to store guids in PostgreSQL. I can view them quite nice within pgAdmin grids. when I select a cell, copy its content and paste it into notepad or sqlsheet ..., the result is: "1ec9:7dfa:eb54:4755:96db:e1bf:9404:3aa9" with double-qu

[pgadmin-support] enhancement request: on Control-Copy please get correct quotes

2007-02-12 Thread Harald Armin Massa
I am using fields of type "inet" to store guids in PostgreSQL. I can view them quite nice within pgAdmin grids. when I select a cell, copy its content and paste it into notepad or sqlsheet ..., the result is: "1ec9:7dfa:eb54:4755:96db:e1bf:9404:3aa9" with double-quotes. PostgreSQL uses doubleq

Re: [pgadmin-support] Query (view) question

2007-02-12 Thread Raymond O'Donnell
Art Fore wrote: Sure would be nice and helpful for postgres if there was an Access like application for postgres that worked as well as Access it does, although There is - it's called pgAdmin! :) Seriously, Access tries to be both a GUI and a database; PostgreSQL is a database only, and does

Re: [pgadmin-support] Query (view) question

2007-02-12 Thread Art Fore
On Mon, 2007-02-12 at 12:00 +0100, Joris Dobbelsteen wrote: > >-Original Message- > >From: [EMAIL PROTECTED] > >[mailto:[EMAIL PROTECTED] On Behalf Of Art Fore > >Sent: maandag 12 februari 2007 11:40 > >To: Pgadmin-Support > >Subject: [pgadmin-support] Query (view) question > > > [snip] >

Re: [pgadmin-support] Query (view) question

2007-02-12 Thread Joris Dobbelsteen
>-Original Message- >From: [EMAIL PROTECTED] >[mailto:[EMAIL PROTECTED] On Behalf Of Art Fore >Sent: maandag 12 februari 2007 11:40 >To: Pgadmin-Support >Subject: [pgadmin-support] Query (view) question > [snip] >I tried this as a view with pgadmin with slight mods, This one >below works

[pgadmin-support] Query (view) question

2007-02-12 Thread Art Fore
I have been trying to get a query going in a postgres database, a simple on at that, and have had no success expcept using Access. Here is the query that works in Access. SELECT remote_ALL_PARTS.PARTNUM, public_datasheet_address.Datasheet & remote_ALL_PARTS.Datasheet AS Expr1, public_datasheet_ad

Re: [pgadmin-support] [SQL] Password Policy

2007-02-12 Thread Richard Huxton
Ezequias Rodrigues da Rocha wrote: Hi list, Is there any password polity that postgresql implement ? It is possible to put a set all no administrators passwords to = '123456' from times and times ? Has anyone implement a dinamic password autentication (the password changes according the date/m