PHP manuál : function.pg-meta-data.html


pg_meta_data

pg_meta_data

(PHP 4 >= 4.3.0, PHP 5)

pg_meta_data --  Get meta data for table

Description

array pg_meta_data ( resource connection, string table_name )

pg_meta_data() returns table definition for table_name as an array.

Warning

This function is EXPERIMENTAL. The behaviour of this function, the name of this function, and anything else documented about this function may change without notice in a future release of PHP. Use this function at your own risk.

Parameters

connection

PostgreSQL database connection resource.

table_name

The name of the table.

Return Values

An array of the table definition, or FALSE on error.

Examples

Example 1. Getting table metadata

<?php
  $dbconn
= pg_connect("dbname=publisher") or die("Could not connect");

  
$meta = pg_meta_data($dbconn, 'authors');
  if (
is_array($meta)) {
      echo
'<pre>';
      
var_dump($meta);
      echo
'</pre>';
  }
?>

The above example will output:

array(3) {
["author"]=>
array(5) {
  ["num"]=>
  int(1)
  ["type"]=>
  string(7) "varchar"
  ["len"]=>
  int(-1)
  ["not null"]=>
  bool(false)
  ["has default"]=>
  bool(false)
}
["year"]=>
array(5) {
  ["num"]=>
  int(2)
  ["type"]=>
  string(4) "int2"
  ["len"]=>
  int(2)
  ["not null"]=>
  bool(false)
  ["has default"]=>
  bool(false)
}
["title"]=>
array(5) {
  ["num"]=>
  int(3)
  ["type"]=>
  string(7) "varchar"
  ["len"]=>
  int(-1)
  ["not null"]=>
  bool(false)
  ["has default"]=>
  bool(false)
}
}

See Also

pg_convert()


webmailWebmail


Zaujímavé linky



inzerat.sk - bezplatna inzercia, inzeraty, autobazar, reality

Slovak companies and manufacturers directory

Katalog slovenskych firiem a vyrobkov

Suppliers and products directory
 created by RealData (2005)
 www.realdata.sk  
Všetky ceny sú s 20% DPH.    Konverzny kurz: 1 EUR = 30,1260 SKK
Ceny nezahŕňajú ročný udržiavací poplatok za doménu, ktorý platíme jednotlivým správcom domén.

stránka vygenerovaná za 0.2544s

webhosting zaregistrujte si domenu