Re: What are schemas? - Mailing list pgsql-novice

From Vijay Deval
Subject Re: What are schemas?
Date
Msg-id 3CDDD006.401241C6@giaspn01.vsnl.net.in
Whole thread Raw
In response to What are schemas?  (Francisco Reyes <lists@natserv.com>)
List pgsql-novice
Francisco Reyes wrote:

> Saw some recent discussions about schemas (hacker email sent to another
> list I read).
>
> What are schemas?
> I have a general/vague idea, but would like to better understand it.

I have created a schema for my electroplating jobshop.  "Fundamentals of
Database Systems" by Elmasri and Navathe was used as reference. The diagram
is in xfig.  If you find that interesting, and would like to get details, I
would be glad to write a note about it. It will be a bit long. "Beginning
Databases with PostgreSQL" by Stones and Mathews also gives  information on
schema.

Vijay
#FIG 3.2
Landscape
Center
Inches
A4
100.00
Single
-2
1200 2
1 2 0 1 0 7 100 0 -1 0.000 1 0.0000 772 2700 337 150 435 2550 1110 2850
1 2 0 1 0 7 100 0 -1 0.000 1 0.0000 532 2017 427 142 105 1875 960 2160
1 2 0 1 0 7 100 0 -1 0.000 1 0.0000 493 1698 345 135 148 1563 838 1833
1 2 0 1 0 7 100 0 -1 0.000 1 0.0000 504 1353 360 150 144 1203 864 1503
1 2 0 1 0 7 100 0 -1 0.000 1 0.0000 1475 1693 300 120 1175 1573 1775 1813
1 2 0 1 0 7 100 0 -1 0.000 1 0.0000 1395 2325 195 120 1200 2205 1590 2445
1 2 0 1 0 7 100 0 -1 0.000 1 0.0000 1139 1010 307 112 832 898 1447 1123
1 2 0 1 0 7 100 0 -1 0.000 1 0.0000 2077 1354 442 127 1635 1227 2520 1482
1 2 0 1 0 7 100 0 -1 0.000 1 0.0000 1470 720 315 135 1155 585 1785 855
1 2 0 1 0 7 100 0 -1 0.000 1 0.0000 2316 703 285 105 2031 598 2601 808
1 2 0 1 0 7 100 0 -1 0.000 1 0.0000 2662 1057 307 142 2355 915 2970 1200
1 2 0 1 0 7 100 0 -1 0.000 1 0.0000 3105 750 210 105 2895 645 3315 855
1 2 0 1 0 7 100 0 -1 0.000 1 0.0000 3382 1057 247 112 3135 945 3630 1170
1 2 0 1 0 7 100 0 -1 0.000 1 0.0000 3412 1395 202 90 3210 1305 3615 1485
1 2 0 1 0 7 100 0 -1 0.000 1 0.0000 3900 1672 480 142 3420 1530 4380 1815
1 2 0 1 0 7 100 0 -1 0.000 1 0.0000 3757 742 262 127 3495 615 4020 870
1 2 0 1 0 7 100 0 -1 0.000 1 0.0000 4185 1005 315 120 3870 885 4500 1125
1 2 0 1 0 7 100 0 -1 0.000 1 0.0000 4560 1297 360 127 4200 1170 4920 1425
1 2 0 1 0 7 100 0 -1 0.000 1 0.0000 5767 1905 247 135 5520 1770 6015 2040
1 2 0 1 0 7 100 0 -1 0.000 1 0.0000 5985 1590 345 150 5640 1440 6330 1740
1 2 0 1 0 7 100 0 -1 0.000 1 0.0000 6277 1290 232 120 6045 1170 6510 1410
1 2 0 1 0 7 100 0 -1 0.000 1 0.0000 6495 855 285 120 6210 735 6780 975
1 2 0 1 0 7 100 0 -1 0.000 1 0.0000 7110 825 300 135 6810 690 7410 960
1 2 0 1 0 7 100 0 -1 0.000 1 0.0000 7365 1147 300 142 7065 1005 7665 1290
1 2 0 1 0 7 100 0 -1 0.000 1 0.0000 7612 1455 277 120 7335 1335 7890 1575
1 2 0 1 0 7 100 0 -1 0.000 1 0.0000 7785 1747 180 97 7605 1650 7965 1845
1 2 0 1 0 7 100 0 -1 0.000 1 0.0000 9525 1687 600 187 8925 1500 10125 1875
1 2 0 1 0 7 100 0 -1 0.000 1 0.0000 9907 1230 382 105 9525 1125 10290 1335
1 2 0 1 0 7 100 0 -1 0.000 1 0.0000 10065 862 240 97 9825 765 10305 960
1 2 0 1 0 7 100 0 -1 0.000 1 0.0000 10260 600 195 120 10065 480 10455 720
1 2 0 1 0 7 100 0 -1 0.000 1 0.0000 10770 930 300 150 10470 780 11070 1080
1 2 0 1 0 7 100 0 -1 0.000 1 0.0000 11152 1290 262 135 10890 1155 11415 1425
1 2 0 1 0 7 100 0 -1 0.000 1 0.0000 10965 4492 285 142 10680 4350 11250 4635
1 2 0 1 0 7 100 0 -1 0.000 1 0.0000 11647 4777 307 112 11340 4665 11955 4890
1 2 0 1 0 7 100 0 -1 0.000 1 0.0000 11572 5077 217 97 11355 4980 11790 5175
1 2 0 1 0 7 100 0 -1 0.000 1 0.0000 11512 5392 232 97 11280 5295 11745 5490
1 2 0 1 0 7 100 0 -1 0.000 1 0.0000 10987 7350 337 150 10650 7200 11325 7500
1 2 0 1 0 7 100 0 -1 0.000 1 0.0000 11557 6982 262 112 11295 6870 11820 7095
1 2 0 1 0 7 100 0 -1 0.000 1 0.0000 11782 7297 262 127 11520 7170 12045 7425
1 2 0 1 0 7 100 0 -1 0.000 1 0.0000 11767 7590 187 105 11580 7485 11955 7695
1 2 0 1 0 7 100 0 -1 0.000 1 0.0000 11805 7897 210 97 11595 7800 12015 7995
1 2 0 1 0 7 100 0 -1 0.000 1 0.0000 11842 8190 262 120 11580 8070 12105 8310
1 2 0 1 0 7 100 0 -1 0.000 1 0.0000 11437 8400 262 120 11175 8280 11700 8520
1 2 0 1 0 7 100 0 -1 0.000 1 0.0000 1350 3997 225 157 1125 3840 1575 4155
1 2 0 1 0 7 100 0 -1 0.000 1 0.0000 787 3997 277 127 510 3870 1065 4125
1 2 0 1 0 7 100 0 -1 0.000 1 0.0000 435 4275 300 105 135 4170 735 4380
1 2 0 1 0 7 100 0 -1 0.000 1 0.0000 442 4590 277 105 165 4485 720 4695
1 2 0 1 0 7 100 0 -1 0.000 1 0.0000 375 4890 285 120 90 4770 660 5010
1 2 0 1 0 7 100 0 -1 0.000 1 0.0000 2265 5145 720 180 1545 4965 2985 5325
1 2 0 1 0 7 100 0 -1 0.000 1 0.0000 1567 5482 262 127 1305 5355 1830 5610
1 2 0 1 0 7 100 0 -1 0.000 1 0.0000 1185 5797 435 142 750 5655 1620 5940
1 2 0 1 0 7 100 0 -1 0.000 1 0.0000 795 6157 195 127 600 6030 990 6285
1 2 0 1 0 7 100 0 -1 0.000 1 0.0000 1147 6480 397 150 750 6330 1545 6630
1 2 1 1 0 7 100 0 -1 4.000 1 0.0000 1552 6847 382 142 1170 6847 1934 6847
1 2 0 1 0 7 100 0 -1 0.000 1 0.0000 6870 7320 480 165 6390 7155 7350 7485
1 2 0 1 0 7 100 0 -1 0.000 1 0.0000 6007 7470 217 105 5790 7365 6225 7575
1 2 1 1 0 7 100 0 -1 4.000 1 0.0000 11677 5700 382 135 11295 5700 12059 5700
1 2 1 1 0 7 100 0 -1 4.000 1 0.0000 11602 4470 262 120 11340 4470 11864 4470
1 2 0 1 0 7 100 0 -1 0.000 1 0.0000 3705 6675 240 135 3465 6540 3945 6810
1 2 0 1 0 7 100 0 -1 0.000 1 0.0000 4417 6720 322 120 4095 6600 4740 6840
1 2 0 1 0 7 100 0 -1 0.000 1 0.0000 4515 7035 300 105 4215 6930 4815 7140
1 2 0 1 0 7 100 0 -1 0.000 1 0.0000 3487 7357 307 112 3180 7245 3795 7470
1 2 0 1 0 7 100 0 -1 0.000 1 0.0000 3082 8340 352 150 2730 8190 3435 8490
1 2 0 1 0 7 100 0 -1 0.000 1 0.0000 4387 8347 217 142 4170 8205 4605 8490
1 2 0 1 0 7 100 0 -1 0.000 1 0.0000 4762 7387 337 112 4425 7275 5100 7500
1 2 1 1 0 7 100 0 -1 4.000 1 0.0000 3780 8347 255 127 3525 8347 4035 8347
1 2 0 1 0 7 100 0 -1 0.000 1 0.0000 3052 7012 592 157 2460 6855 3645 7170
1 2 0 1 0 7 100 0 -1 0.000 1 0.0000 1927 442 337 127 1590 315 2265 570
2 1 0 1 0 7 100 0 -1 0.000 0 0 -1 0 0 2
     570 2790 975 2790
2 2 0 1 0 7 100 0 -1 0.000 0 0 -1 0 0 5
     1965 2025 3075 2025 3075 2415 1965 2415 1965 2025
2 1 0 1 0 7 100 0 -1 0.000 0 0 -1 0 0 2
     1110 2670 1965 2385
2 1 0 1 0 7 100 0 -1 0.000 0 0 -1 0 0 2
     975 2025 1245 1800
2 1 0 1 0 7 100 0 -1 0.000 0 0 -1 0 0 2
     855 1710 1200 1695
2 1 0 1 0 7 100 0 -1 0.000 0 0 -1 0 0 2
     870 1410 1290 1605
2 1 0 1 0 7 100 0 -1 0.000 0 0 -1 0 0 2
     1650 1800 1950 2055
2 1 0 1 0 7 100 0 -1 0.000 0 0 -1 0 0 2
     1605 2310 1950 2235
2 1 0 1 0 7 100 0 -1 0.000 0 0 -1 0 0 2
     1350 1080 1650 1320
2 1 0 1 0 7 100 0 -1 0.000 0 0 -1 0 0 2
     1635 855 1770 1275
2 1 0 1 0 7 100 0 -1 0.000 0 0 -1 0 0 2
     1875 555 1875 1245
2 1 0 1 0 7 100 0 -1 0.000 0 0 -1 0 0 2
     2220 840 2070 1230
2 1 0 1 0 7 100 0 -1 0.000 0 0 -1 0 0 2
     2070 1485 2070 2025
2 1 0 1 0 7 100 0 -1 0.000 0 0 -1 0 0 2
     2595 1215 2595 2025
2 1 0 1 0 7 100 0 -1 0.000 0 0 -1 0 0 2
     3045 870 2895 2040
2 1 0 1 0 7 100 0 -1 0.000 0 0 -1 0 0 2
     3180 1125 2955 2025
2 1 0 1 0 7 100 0 -1 0.000 0 0 -1 0 0 2
     3285 1470 3015 2040
2 1 0 1 0 7 100 0 -1 0.000 0 0 -1 0 0 2
     3495 1755 3090 2115
2 1 0 1 0 7 100 0 -1 0.000 0 0 -1 0 0 2
     3735 870 3720 1545
2 1 0 1 0 7 100 0 -1 0.000 0 0 -1 0 0 2
     3990 1110 3885 1530
2 1 0 1 0 7 100 0 -1 0.000 0 0 -1 0 0 2
     4230 1335 4005 1530
2 1 0 1 0 7 100 0 -1 0.000 0 0 -1 0 0 5
     3975 2250 4725 1650 5475 2250 4725 2850 3975 2250
2 2 0 1 0 7 100 0 -1 0.000 0 0 -1 0 0 5
     6165 2085 7275 2085 7275 2475 6165 2475 6165 2085
2 1 0 1 0 7 100 0 -1 0.000 0 0 -1 0 0 2
     3975 2250 3075 2250
2 1 0 1 0 7 100 0 -1 0.000 0 0 -1 0 0 2
     5475 2250 6150 2250
2 1 0 1 0 7 100 0 -1 0.000 0 0 -1 0 0 5
     7800 2250 8550 1650 9300 2250 8550 2850 7800 2250
2 2 0 1 0 7 100 0 -1 0.000 0 0 -1 0 0 5
     9825 2025 11025 2025 11025 2475 9825 2475 9825 2025
2 1 0 1 0 7 100 0 -1 0.000 0 0 -1 0 0 2
     7800 2250 7275 2250
2 1 0 1 0 7 100 0 -1 0.000 0 0 -1 0 0 2
     9300 2250 9825 2250
2 1 0 1 0 7 100 0 -1 0.000 0 0 -1 0 0 5
     9735 3705 10485 3105 11235 3705 10485 4305 9735 3705
2 1 0 1 0 7 100 0 -1 0.000 0 0 -1 0 0 1
     10320 3735
2 1 0 1 0 7 100 0 -1 0.000 0 0 -1 0 0 2
     9660 3705 10500 3045
2 1 0 1 0 7 100 0 -1 0.000 0 0 -1 0 0 2
     10515 3060 11295 3705
2 1 0 1 0 7 100 0 -1 0.000 0 0 -1 0 0 2
     11295 3720 10485 4365
2 1 0 1 0 7 100 0 -1 0.000 0 0 -1 0 0 2
     10470 4350 9660 3690
2 2 0 1 0 7 100 0 -1 0.000 0 0 -1 0 0 5
     9990 4935 11100 4935 11100 5325 9990 5325 9990 4935
2 2 0 1 0 7 100 0 -1 0.000 0 0 -1 0 0 5
     825 4275 1935 4275 1935 4665 825 4665 825 4275
2 1 0 1 0 7 100 0 -1 0.000 0 0 -1 0 0 2
     5625 1980 5925 1980
2 1 0 1 0 7 100 0 -1 0.000 0 0 -1 0 0 2
     5970 1995 6180 2130
2 1 0 1 0 7 100 0 -1 0.000 0 0 -1 0 0 2
     6225 1725 6315 2085
2 1 0 1 0 7 100 0 -1 0.000 0 0 -1 0 0 2
     6405 1395 6405 2070
2 1 0 1 0 7 100 0 -1 0.000 0 0 -1 0 0 2
     6585 975 6585 2085
2 1 0 1 0 7 100 0 -1 0.000 0 0 -1 0 0 2
     6915 945 6705 2085
2 1 0 1 0 7 100 0 -1 0.000 0 0 -1 0 0 2
     7140 1245 6825 2085
2 1 0 1 0 7 100 0 -1 0.000 0 0 -1 0 0 2
     7365 1485 6885 2085
2 1 0 1 0 7 100 0 -1 0.000 0 0 -1 0 0 2
     7620 1785 7050 2085
2 1 0 1 0 7 100 0 -1 0.000 0 0 -1 0 0 2
     9105 1755 9960 1755
2 1 0 1 0 7 100 0 -1 0.000 0 0 -1 0 0 2
     10155 1320 10305 2025
2 1 0 1 0 7 100 0 -1 0.000 0 0 -1 0 0 2
     9930 1830 9960 2040
2 1 0 1 0 7 100 0 -1 0.000 0 0 -1 0 0 2
     10260 930 10485 2025
2 1 0 1 0 7 100 0 -1 0.000 0 0 -1 0 0 2
     10335 735 10560 2025
2 1 0 1 0 7 100 0 -1 0.000 0 0 -1 0 0 2
     10665 1065 10665 2025
2 1 0 1 0 7 100 0 -1 0.000 0 0 -1 0 0 2
     10965 1380 10830 2040
2 1 0 1 0 7 100 0 -1 0.000 0 0 -1 0 0 2
     10515 3045 10515 2475
2 1 0 1 0 7 100 0 -1 0.000 0 0 -1 0 0 2
     10500 4365 10500 4935
2 1 0 1 0 7 100 0 -1 0.000 0 0 -1 0 0 2
     10470 4365 10470 4935
2 1 0 1 0 7 100 0 -1 0.000 0 0 -1 0 0 2
     10770 4575 11145 4575
2 1 0 1 0 7 100 0 -1 0.000 0 0 -1 0 0 2
     10905 4635 10755 4935
2 1 0 1 0 7 100 0 -1 0.000 0 0 -1 0 0 2
     11355 4530 10920 4920
2 1 0 1 0 7 100 0 -1 0.000 0 0 -1 0 0 2
     11340 4800 11040 4935
2 1 0 1 0 7 100 0 -1 0.000 0 0 -1 0 0 2
     11340 5085 11100 5085
2 1 0 1 0 7 100 0 -1 0.000 0 0 -1 0 0 2
     11310 5340 11085 5220
2 1 0 1 0 7 100 0 -1 0.000 0 0 -1 0 0 2
     11325 5655 10980 5325
2 2 0 1 0 7 100 0 -1 0.000 0 0 -1 0 0 5
     9975 7575 11175 7575 11175 8025 9975 8025 9975 7575
2 1 0 1 0 7 100 0 -1 0.000 0 0 -1 0 0 5
     9818 6516 10568 5916 11318 6516 10568 7116 9818 6516
2 1 0 1 0 7 100 0 -1 0.000 0 0 -1 0 0 2
     10575 5925 10575 5325
2 1 0 1 0 7 100 0 -1 0.000 0 0 -1 0 0 2
     10605 7095 10605 7575
2 1 0 1 0 7 100 0 -1 0.000 0 0 -1 0 0 2
     10575 7110 10575 7590
2 1 0 1 0 7 100 0 -1 0.000 0 0 -1 0 0 2
     11640 7365 11970 7365
2 1 0 1 0 7 100 0 -1 0.000 0 0 -1 0 0 2
     10785 7485 10785 7590
2 1 0 1 0 7 100 0 -1 0.000 0 0 -1 0 0 2
     11475 7095 11175 7800
2 1 0 1 0 7 100 0 -1 0.000 0 0 -1 0 0 2
     11550 7365 11175 7800
2 1 0 1 0 7 100 0 -1 0.000 0 0 -1 0 0 2
     11595 7635 11175 7830
2 1 0 1 0 7 100 0 -1 0.000 0 0 -1 0 0 2
     11595 7905 11190 7890
2 1 0 1 0 7 100 0 -1 0.000 0 0 -1 0 0 2
     11610 8160 11175 7980
2 1 0 1 0 7 100 0 -1 0.000 0 0 -1 0 0 2
     11280 8310 11010 8025
2 1 0 1 0 7 100 0 -1 0.000 0 0 -1 0 0 5
     7919 7850 8669 7250 9419 7850 8669 8450 7919 7850
2 1 0 1 0 7 100 0 -1 0.000 0 0 -1 0 0 5
     7845 7845 8670 7185 9495 7845 8685 8505 7845 7830
2 2 0 1 0 7 100 0 -1 0.000 0 0 -1 0 0 5
     5850 7650 7275 7650 7275 8025 5850 8025 5850 7650
2 2 0 1 0 7 100 0 -1 0.000 0 0 -1 0 0 5
     1950 5775 3375 5775 3375 6150 1950 6150 1950 5775
2 1 0 1 0 7 100 0 -1 0.000 0 0 -1 0 0 5
     1068 3345 1818 2745 2568 3345 1818 3945 1068 3345
2 1 0 1 0 7 100 0 -1 0.000 0 0 -1 0 0 5
     2283 4076 3033 3476 3783 4076 3033 4676 2283 4076
2 1 0 1 0 7 100 0 -1 0.000 0 0 -1 0 0 5
     2205 4080 3030 3420 3855 4080 3045 4740 2205 4065
2 2 0 1 0 7 100 0 -1 0.000 0 0 -1 0 0 5
     1875 5700 3450 5700 3450 6225 1875 6225 1875 5700
2 1 0 1 0 7 100 0 -1 0.000 0 0 -1 0 0 2
     1215 4065 1440 4065
2 1 0 1 0 7 100 0 -1 0.000 0 0 -1 0 0 2
     645 4860 840 4665
2 1 0 1 0 7 100 0 -1 0.000 0 0 -1 0 0 2
     735 4560 810 4560
2 1 0 1 0 7 100 0 -1 0.000 0 0 -1 0 0 2
     720 4320 810 4380
2 1 0 1 0 7 100 0 -1 0.000 0 0 -1 0 0 2
     945 4110 1020 4260
2 1 0 1 0 7 100 0 -1 0.000 0 0 -1 0 0 2
     1335 4170 1335 4275
2 1 0 1 0 7 100 0 -1 0.000 0 0 -1 0 0 2
     3045 3420 2970 2415
2 1 0 1 0 7 100 0 -1 0.000 0 0 -1 0 0 2
     1815 2760 2280 2430
2 1 0 1 0 7 100 0 -1 0.000 0 0 -1 0 0 2
     1845 2775 2355 2415
2 1 0 1 0 7 100 0 -1 0.000 0 0 -1 0 0 3
     1800 3930 1800 4275 1785 4275
2 1 0 1 0 7 100 0 -1 0.000 0 0 -1 0 0 2
     1830 3945 1830 4275
2 1 0 1 0 7 100 0 -1 0.000 0 0 -1 0 0 2
     3075 4740 3075 5700
2 1 0 1 0 7 100 0 -1 0.000 0 0 -1 0 0 2
     3045 4740 3045 5685
2 1 0 1 0 7 100 0 -1 0.000 0 0 -1 0 0 2
     1665 5205 2850 5205
2 1 0 1 0 7 100 0 -1 0.000 0 0 -1 0 0 2
     2625 5310 2625 5685
2 1 0 1 0 7 100 0 -1 0.000 0 0 -1 0 0 2
     1845 5490 2235 5700
2 1 0 1 0 7 100 0 -1 0.000 0 0 -1 0 0 2
     1635 5805 1890 5805
2 1 0 1 0 7 100 0 -1 0.000 0 0 -1 0 0 2
     1005 6165 1875 5940
2 1 0 1 0 7 100 0 -1 0.000 0 0 -1 0 0 2
     1545 6420 1875 6135
2 1 0 1 0 7 100 0 -1 0.000 0 0 -1 0 0 2
     1740 6705 2220 6225
2 1 0 1 0 7 100 0 -1 0.000 0 0 -1 0 0 2
     7860 7845 7275 7845
2 1 0 1 0 7 100 0 -1 0.000 0 0 -1 0 0 2
     7875 7875 7275 7875
2 1 0 1 0 7 100 0 -1 0.000 0 0 -1 0 0 2
     9495 7860 9975 7860
2 1 0 1 0 7 100 0 -1 0.000 0 0 -1 0 0 5
     6150 6000 6900 5400 7650 6000 6900 6600 6150 6000
2 1 0 1 0 7 100 0 -1 0.000 0 0 -1 0 0 5
     6078 6011 6903 5351 7728 6011 6918 6671 6078 5996
2 1 0 1 0 7 100 0 -1 0.000 0 0 -1 0 0 5
     8115 6240 8865 5640 9615 6240 8865 6840 8115 6240
2 1 0 1 0 7 100 0 -1 0.000 0 0 -1 0 0 2
     8865 6855 7170 7650
2 1 0 1 0 7 100 0 -1 0.000 0 0 -1 0 0 2
     8865 5670 10005 5145
2 1 0 1 0 7 100 0 -1 0.000 0 0 -1 0 0 2
     6915 6675 4425 7980
2 1 0 1 0 7 100 0 -1 0.000 0 0 -1 0 0 2
     7725 6000 9705 3690
2 1 0 1 0 7 100 0 -1 0.000 0 0 -1 0 0 2
     6900 5385 9870 2460
2 1 0 1 0 7 100 0 -1 0.000 0 0 -1 0 0 2
     6480 7410 7245 7410
2 1 0 1 0 7 100 0 -1 0.000 0 0 -1 0 0 3
     6165 7560 6300 7650 6405 7650
2 1 0 1 0 7 100 0 -1 0.000 0 0 -1 0 0 2
     6585 7470 6525 7650
2 1 0 1 0 7 100 0 -1 0.000 0 0 -1 0 0 5
     1101 7810 1926 7150 2751 7810 1941 8470 1101 7795
2 1 0 1 0 7 100 0 -1 0.000 0 0 -1 0 0 5
     1170 7815 1920 7215 2670 7815 1920 8415 1170 7815
2 1 0 1 0 7 100 0 -1 0.000 0 0 -1 0 0 2
     1935 7170 3000 6240
2 1 0 1 0 7 100 0 -1 0.000 0 0 -1 0 0 2
     2745 7815 3135 7815
2 1 0 1 0 7 100 0 -1 0.000 0 0 -1 0 0 2
     2730 7845 3150 7845
2 2 0 1 0 7 100 0 -1 0.000 0 0 -1 0 0 5
     3150 7725 4425 7725 4425 8100 3150 8100 3150 7725
2 1 0 1 0 7 100 0 -1 0.000 0 0 -1 0 0 2
     2790 7155 3300 7725
2 1 0 1 0 7 100 0 -1 0.000 0 0 -1 0 0 2
     3450 7485 3450 7725
2 1 0 1 0 7 100 0 -1 0.000 0 0 -1 0 0 2
     3810 6810 3900 7725
2 1 0 1 0 7 100 0 -1 0.000 0 0 -1 0 0 2
     4155 6795 4020 7710
2 1 0 1 0 7 100 0 -1 0.000 0 0 -1 0 0 2
     4290 7110 4125 7740
2 1 0 1 0 7 100 0 -1 0.000 0 0 -1 0 0 2
     3240 8205 3255 8100
2 1 0 1 0 7 100 0 -1 0.000 0 0 -1 0 0 2
     3735 8235 3750 8100
2 1 0 1 0 7 100 0 -1 0.000 0 0 -1 0 0 2
     4275 8220 4245 8100
2 1 0 1 0 7 100 0 -1 0.000 0 0 -1 0 0 2
     4530 7470 4290 7725
2 1 0 1 0 7 100 0 -1 0.000 0 0 -1 0 0 2
     2580 7080 3465 7080
4 0 0 100 0 2 12 0.0000 4 180 540 525 2730 jobkey\001
4 0 0 100 0 0 12 0.0000 4 180 585 255 2070 jobcode\001
4 0 0 100 0 0 12 0.0000 4 135 585 210 1770 returnid\001
4 0 0 100 0 0 12 0.0000 4 180 630 225 1410 jobname\001
4 0 0 100 0 0 12 0.0000 4 135 510 1230 1770 details\001
4 0 0 100 0 0 12 0.0000 4 135 270 1230 2385 clid\001
4 0 0 100 0 0 12 0.0000 4 135 750 1755 1410 undercoat\001
4 0 0 100 0 0 12 0.0000 4 180 495 2085 765 u2gms\001
4 0 0 100 0 0 12 0.0000 4 180 510 2430 1095 plating\001
4 0 0 100 0 0 12 0.0000 4 135 315 2955 795 gms\001
4 0 0 100 0 0 12 0.0000 4 135 375 3240 1125 units\001
4 0 0 100 0 0 12 0.0000 4 135 765 3495 1725 text descr\001
4 0 0 100 0 0 12 0.0000 4 105 300 3285 1455 rate\001
4 0 0 100 0 0 12 0.0000 4 135 435 3555 810 billstr\001
4 0 0 100 0 0 12 0.0000 4 180 525 3915 1065 helpstr\001
4 0 0 100 0 0 12 0.0000 4 180 615 4275 1350 descript\001
4 0 0 100 0 2 16 0.0000 4 195 450 2235 2310 JOB\001
4 0 0 100 0 2 16 0.0000 4 165 840 6300 2400 INMAT\001
4 0 0 100 0 0 12 0.0000 4 135 645 4275 2325 received\001
4 0 0 100 0 2 16 0.0000 4 165 1095 9900 2325 OUTMAT\001
4 0 0 100 0 0 12 0.0000 4 135 630 8100 2325 returned\001
4 0 0 100 0 0 12 0.0000 4 150 645 10050 3795 compute\001
4 0 0 100 0 2 16 0.0000 4 165 570 10275 5220 BILL\001
4 0 0 100 0 2 17 0.0000 4 165 915 945 4575 CLIENT\001
4 0 0 100 0 0 12 0.0000 4 180 495 5775 1650 jobkey\001
4 0 0 100 0 0 12 0.0000 4 135 270 6150 1350 clid\001
4 0 0 100 0 0 12 0.0000 4 135 405 6300 900 indoc\001
4 0 0 100 0 0 12 0.0000 4 135 465 6900 900 indate\001
4 0 0 100 0 0 12 0.0000 4 180 375 7200 1200 inqty\001
4 0 0 100 0 0 12 0.0000 4 105 390 7425 1500 ratex\001
4 0 0 100 0 0 12 0.0000 4 90 180 7725 1800 oc\001
4 0 0 100 0 2 12 0.0000 4 180 330 5625 1950 inky\001
4 0 0 100 0 2 12 0.0000 4 180 975 9075 1725 ourchln,inky\001
4 0 0 100 0 0 12 0.0000 4 135 570 9600 1275 outdate\001
4 0 0 100 0 0 12 0.0000 4 150 330 9900 900 oqty\001
4 0 0 100 0 0 12 0.0000 4 135 270 10125 675 clid\001
4 0 0 100 0 0 12 0.0000 4 180 495 10575 975 jobkey\001
4 0 0 100 0 0 12 0.0000 4 135 405 10950 1350 billno\001
4 0 0 100 0 2 12 0.0000 4 135 420 10770 4545 billno\001
4 0 0 100 0 0 12 0.0000 4 135 375 11415 4545 bamt\001
4 0 0 100 0 0 12 0.0000 4 135 420 11445 4860 bdate\001
4 0 0 100 0 0 12 0.0000 4 135 270 11430 5145 clid\001
4 0 0 100 0 0 12 0.0000 4 105 240 11385 5460 tax\001
4 0 0 100 0 0 12 0.0000 4 135 585 11385 5745 balance\001
4 0 0 100 0 2 16 0.0000 4 165 1050 10050 7875 RECEIPT\001
4 0 0 100 0 0 12 0.0000 4 135 555 10275 6450 receive\001
4 0 0 100 0 0 12 0.0000 4 150 735 10200 6675   payment\001
4 0 0 100 0 0 12 0.0000 4 105 555 10725 7395 amount\001
4 0 0 100 0 0 12 0.0000 4 135 330 11400 7050 date\001
4 0 0 100 0 0 12 0.0000 4 135 270 11625 7650 clid\001
4 0 0 100 0 0 12 0.0000 4 135 360 11625 7950 cach\001
4 0 0 100 0 0 12 0.0000 4 180 450 11625 8250 chqno\001
4 0 0 100 0 0 12 0.0000 4 135 360 11250 8475 bank\001
4 0 0 100 0 2 12 0.0000 4 120 360 11625 7350 trnm\001
4 0 0 100 0 0 12 0.0000 4 150 330 8475 7650 post\001
4 0 0 100 0 0 12 0.0000 4 180 645 8175 7875   against\001
4 0 0 100 0 0 12 0.0000 4 135 540 8175 8100    billno\001
4 0 0 100 0 2 16 0.0000 4 165 1320 5925 7950 BILLTRNM\001
4 0 0 100 0 0 12 0.0000 4 90 405 1650 3150 owns\001
4 0 0 100 0 0 12 0.0000 4 180 225 1725 3450 job\001
4 0 0 100 0 0 12 0.0000 4 135 420 2700 3900 client\001
4 0 0 100 0 0 12 0.0000 4 180 615 2700 4350 job strip\001
4 0 0 100 0 2 16 0.0000 4 165 1215 2025 6075 RECSTRIP\001
4 0 0 100 0 0 12 0.0000 4 90 405 600 4050 name\001
4 0 0 100 0 0 12 0.0000 4 135 420 225 4350 addr1\001
4 0 0 100 0 0 12 0.0000 4 135 420 225 4650 addr2\001
4 0 0 100 0 0 12 0.0000 4 135 420 150 4950 addr3\001
4 0 0 100 0 2 12 0.0000 4 135 270 1200 4050 clid\001
4 0 0 100 0 2 12 0.0000 4 180 1275 1650 5175 ourchln,spoolno\001
4 0 0 100 0 0 12 0.0000 4 180 600 900 5850 spoolwt\001
4 0 0 100 0 0 12 0.0000 4 180 615 825 6525 stripped\001
4 0 0 100 0 0 12 0.0000 4 180 540 1275 6900 agused\001
4 0 0 100 0 0 12 0.0000 4 180 315 1425 5550 inky\001
4 0 0 100 0 0 12 0.0000 4 135 240 675 6225 iwt\001
4 0 0 100 0 0 12 0.0000 4 135 360 6720 5760 send\001
4 0 0 100 0 0 12 0.0000 4 180 1110 6390 6180 and "compute"\001
4 0 0 100 0 0 12 0.0000 4 135 1095 6390 5985 data to outmat\001
4 0 0 100 0 0 12 0.0000 4 135 510 8565 6105 reduce\001
4 0 0 100 0 0 12 0.0000 4 180 810 8400 6360 balance by\001
4 0 0 100 0 0 12 0.0000 4 135 660 8400 6585      "amt"\001
4 0 0 100 0 0 12 0.0000 4 105 510 5865 7530 amt     \001
4 0 0 100 0 2 12 0.0000 4 165 840 6480 7380 billno,trnm\001
4 0 0 100 0 0 12 0.0000 4 135 555 1620 7590  collate\001
4 0 0 100 0 0 12 0.0000 4 180 990 1425 7815 data for easy\001
4 0 0 100 0 0 12 0.0000 4 135 1035 1290 8010        reference\001
4 0 0 100 0 2 16 0.0000 4 165 1170 3225 8025 LTTRANS\001
4 0 0 100 0 0 12 0.0000 4 150 480 3255 7410 agrate\001
4 0 0 100 0 0 12 0.0000 4 135 360 3540 6735 pono\001
4 0 0 100 0 0 12 0.0000 4 180 510 4155 6765 podate\001
4 0 0 100 0 0 12 0.0000 4 180 510 4245 7080 agdate\001
4 0 0 100 0 0 12 0.0000 4 135 525 4515 7440 remark\001
4 0 0 100 0 0 12 0.0000 4 180 1725 2835 8400 agused     eqcu      oqty\001
4 0 0 100 0 0 12 0.0000 4 135 360 2730 4140 L&T\001
4 0 0 100 0 2 12 0.0000 4 180 975 2565 7050 ourchln,inky\001
4 0 0 100 0 0 12 0.0000 4 135 510 900 1050 ucoat1\001
4 0 0 100 0 0 12 0.0000 4 180 495 1275 750 u1gms\001
4 0 0 100 0 0 12 0.0000 4 135 510 1665 510 ucoat2\001

pgsql-novice by date:

Previous
From: hodges@xprt.net
Date:
Subject: Re: Time Formatting
Next
From: john-paul delaney
Date:
Subject: newbie: Column CHECK(col contains '@') ?