Tech:Database Objects
From Cyclopath
FIXME: document:
salt_new() pw_hash() password_set() login_ok() fix() rid_inf() revision_geometry() revision_geosummary_update() public | aadt | table | cycling public | annot_bs | table | cycling public | annot_bs_geo | view | cycling public | annotation | table | cycling public | annotation_geo | view | cycling public | basemap_polygon | table | cycling public | basemap_polygon_type | table | cycling public | bikeways_qgis | table | cycling public | bmpolygon_joined_current | view | cycling public | byway_joined_current | view | cycling public | byway_joined_current_aadt | view | cycling public | byway_name_cache | table | cycling public | byway_node | table | cycling public | byway_rating | table | cycling public | byway_segment | table | cycling public | byway_segment_aadt | view | cycling public | byway_type | table | cycling public | county | table | cycling public | draw_class | table | cycling public | draw_param | table | cycling public | draw_param_joined | view | cycling public | exp_byway_comments | table | cycling public | exp_point | view | cycling public | exp_point_comment | view | cycling public | exp_point_comments | table | cycling public | exp_rating | table | cycling public | exp_rating_byway | view | cycling public | feature_id_seq | sequence | cycling public | geofeature | view | cycling public | geometry_columns | table | cycling public | key_value_pair | table | cycling public | mndot_basemap | view | cycling public | mndot_basemap_muni | table | cycling public | mndot_basemap_muni_gid_seq | sequence | cycling public | mndot_basemap_tweaked | table | cycling public | mndot_basemap_tweaked_gid_seq | sequence | cycling public | mndot_bikeways | view | cycling public | mndot_bikeways_tweaked | table | cycling public | mndot_bikeways_tweaked_gid_seq | sequence | cycling public | point | table | cycling public | point_type | table | cycling public | revision | table | cycling public | revision_id_seq | sequence | cycling public | route | table | cycling public | route_digest | table | cycling public | route_digest_id_seq | sequence | cycling public | route_step | table | cycling public | spatial_ref_sys | table | cycling public | tilecache_lock | table | cycling public | tis_basemap_joined | view | cycling public | tisdata | table | cycling public | urban_area | table | cycling public | urban_area_gid_seq | sequence | cycling public | user_ | table | cycling
[edit] Verifying login credentials
Use the database function. E.g.,
SELECT login_ok('gbush', 'verysecret');
This will return true if the username/password pair plus other factors are sufficient to permit login, false otherwise.
[edit] Resetting a password
E.g., to set user gbush's password to verysecret, regardless of its previous value:
SELECT password_set('gbush', 'verysecret');
