Thread

1. Re: hidden data fields

   mikeo <mikeo@spectrumtelecorp.com> — 2000-08-22T18:52:26Z

   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><<<<<<<<
   
   
   
   
   

2. hidden data fields

   Mike Sears <msears@vianet.ca> — 2000-08-22T21:10:27Z

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

3. Re: hidden data fields

   Gilles DAROLD <gilles@darold.net> — 2000-08-23T08:09:17Z

   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,