Postgres Pro
Downloads
Home   >   mailing lists

How to Create View - Mailing list pgsql-general

From Muhyiddin A.M Hayat
Subject How to Create View
Date
Msg-id 003901c392ff$24c1c3e0$1f00a8c0@middinkcomp
Whole thread Raw
Responses Re: How to Create View
List pgsql-general
Tree view
Dear all,
 
I Have This table
 
 
Table Billing:
 
        id       trx_date       trx_time     depart       payment_method    billing_amount    amount_paid     balance       creator
         1      10/09/2003  21:55:02   Resto        Visa                           13.800,00                 10.000,00       3.800,00       middink
Table Payment
 
        id r   trx_date        trx_time        descriptions   payment_method   amount      creator
         1     10/08/2003  18:17:40      Payment          Cash                         2.000,00     middink
 
 
I would like to create "View " from above table with result look like:
 
 
trx_date       trx_time     descriptions                                                             payment_method   debet               credit             balance         creator
10/09/2003  21:55:02   Resto  Billing  13.800,00 Paid: 10.000,00         Visa                          3.800,00                               3.800,00         middink
10/08/2003  18:17:40    Payment                                                                  Cash                                                2.000,00       1.800,00          middink
 
 
How can I create View like above?

pgsql-general by date:

Previous
From: Tino Wildenhain
Date:
Subject: Re: PG clustering
Next
From: Mike Leahy
Date:
Subject: Re: Indexes?