Select statement

From: dave go <godave621(at)yahoo(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Select statement
Date: 2001-05-21 19:01:40
Message-ID: 20010521190140.22373.qmail@web9402.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I am trying create a new table A from table B. On B
(b1, b2, b3, b4 ) I would like create a table A (a1,
a2, a3) where a2 is b2 and b3.

example:
A)

Id, lastname, Firstname, MInit
------------------------------

B)

Id, Name, MInit
---------------

Thanks very much for your help,
Dave

__________________________________________________
Do You Yahoo!?
Yahoo! Auctions - buy the things you want at great prices
http://auctions.yahoo.com/

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Abhimanyu_Bhola 2001-05-21 19:33:57 RE: how to install postgresql
Previous Message Tom Lane 2001-05-21 18:55:25 Re: Memory usage and pg_dump