using adbin, conbin, etc.

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.

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

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

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