Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $con = pg_connect("dbname=residencia1 host=localhost user=postgres password=123456");
- $q = pg_query("SELECT * FROM pg_tables");
- $not_display = array("pg_statistic","pg_type","pg_attribute","pg_proc","pg_class","pg_attrdef","pg_constraint","pg_index","pg_operator","pg_opfamily","pg_opclass","pg_am","pg_largeobject_metadata","pg_shdescription","pg_collation","pg_amop","pg_amproc","pg_language","pg_aggregate","pg_rewrite","pg_description","pg_cast","pg_conversion","pg_depend","pg_ts_config_map","pg_ts_dict","pg_ts_parser","pg_ts_template","pg_init_privs","pg_pltemplate","pg_ts_config","pg_range","pg_transform","sql_sizing_profiles","sql_sizing","sql_parts","sql_packages","sql_languages","sql_implementation_info","sql_features");
- while($r=pg_fetch_object($q)){
- $tabla = $r->tablename;
- if(!in_array($tabla, $not_display)){
- echo "<h3>$tabla</h3>";
- $query = 'select * from '.$tabla;
- $result = pg_query($query);
- $i = 0;
- echo '<table border=1><tr>';
- while ($i < pg_num_fields($result))
- {
- $fieldName = pg_field_name($result, $i);
- $fieldType = pg_field_type($result, $i);
- echo '<td><b>' . $fieldName . '</b> ('.$fieldType.')</td>';
- $i = $i + 1;
- }
- echo '</tr>';
- $i = 0;
- while ($row = pg_fetch_row($result))
- {
- echo '<tr>';
- $count = count($row);
- $y = 0;
- while ($y < $count)
- {
- $c_row = current($row);
- echo '<td>' . $c_row . '</td>';
- next($row);
- $y = $y + 1;
- }
- echo '</tr>';
- $i = $i + 1;
- }
- pg_free_result($result);
- echo '</table>';
- }
- }
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement