Postgres Pro
Downloads
Home   >   mailing lists

Thread: using adbin, conbin, etc.

using adbin, conbin, etc.

From
"Christopher Kings-Lynne"
Date:
Hi guys,

I hear that we're supposed to use the 'bin' versions of the 'src' columns
where possible. I would like then to use them in phpPgAdmin for displaying
defaults and stuff.  Is there some way to use them from SQL?  Cos it all
looks like garbage to me :)

Chris

Re: using adbin, conbin, etc.

From
Rod Taylor
Date:
On Tue, 2003-07-29 at 21:45, Christopher Kings-Lynne wrote:
> Hi guys,
>
> I hear that we're supposed to use the 'bin' versions of the 'src' columns
> where possible. I would like then to use them in phpPgAdmin for displaying
> defaults and stuff.  Is there some way to use them from SQL?  Cos it all
> looks like garbage to me :)

Use the various pg_get_...() functions wherever you can.

Re: using adbin, conbin, etc.

From
Tom Lane
Date:
Rod Taylor <rbt@rbt.ca> writes:
> On Tue, 2003-07-29 at 21:45, Christopher Kings-Lynne wrote:
>> I hear that we're supposed to use the 'bin' versions of the 'src' columns
>> where possible. I would like then to use them in phpPgAdmin for displaying
>> defaults and stuff.  Is there some way to use them from SQL?  Cos it all
>> looks like garbage to me :)

> Use the various pg_get_...() functions wherever you can.

And if you can't find one that does what you want, ask for it.
The last thing we want is client-side code digging into those internal
representations --- we change 'em frequently.
        regards, tom lane

Re: using adbin, conbin, etc.

From
"Christopher Kings-Lynne"
Date:
> > Use the various pg_get_...() functions wherever you can.
> 
> And if you can't find one that does what you want, ask for it.
> The last thing we want is client-side code digging into those internal
> representations --- we change 'em frequently.

I want pg_get_* functions for every PostgreSQL object :P

Chris

Re: using adbin, conbin, etc.

From
"Christopher Kings-Lynne"
Date:
> > And if you can't find one that does what you want, ask for it.
> > The last thing we want is client-side code digging into those internal
> > representations --- we change 'em frequently.
>
> I want pg_get_* functions for every PostgreSQL object :P

And I want an easy way of parsing aclitem[]'s so I don't have to do it
manually in PHP, trying to handle usernames and grantors that have commas,
spaces, backslashes and double quotes in them...

Chris