Обсуждение: hidden data fields

you could "hide" or mask columns through views...


mikeo



At 02:10 PM 8/22/00 -0700, Mike Sears wrote:

>>>>

<excerpt><fontfamily><param>Arial</param><smaller>In mysql you can make
some data apear to be garbled or hiddne, I'm wondering if this can be
done using psql?

</smaller></fontfamily>

</excerpt><<<<<<<<

Mike Sears wrote:

> In mysql you can make some data apear to be garbled or hiddne, I'm
> wondering if this can be done using psql?

Unlike MySQL there is no hidden type for your data, but you can use the
pg_user example,
see below :

%> psql template1

template1=> select * from pg_user;
postgres|      26|t          |t       |t       |t        |********|Sat
Jan 31 07:00:00 2037 CET

The password file is "hidden", but how ?
just type :

template1=> \d pg_user
View    = pg_user
Query   = SELECT "pg_shadow"."usename", "pg_shadow"."usesysid",
"pg_shadow"."usecreatedb", "pg_shadow"."usetrace",
"pg_shadow"."usesuper", "pg_shadow"."usecatupd", '********'::"text" AS
"passwd", "pg_shadow"."valuntil" FROM "pg_shadow";
+----------------------------------+----------------------------------+-------+

|              Field               |              Type                |
Length|
+----------------------------------+----------------------------------+-------+

| usename                          | name
|    32 |
| usesysid                         | int4
|     4 |
| usecreatedb                      | bool
|     1 |
| usetrace                         | bool
|     1 |
| usesuper                         | bool
|     1 |
| usecatupd                        | bool
|     1 |
| passwd                           | text
|   var |
| valuntil                         | abstime
|     4 |
+----------------------------------+----------------------------------+-------+

Not very useful, but it can be done...

Regards,