Select statement - Mailing list pgsql-general

From dave go
Subject Select statement
Date
Msg-id 20010521190140.22373.qmail@web9402.mail.yahoo.com
Whole thread Raw
List 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/

pgsql-general by date:

Previous
From: "Denis A. Doroshenko"
Date:
Subject: Re: psql shell problem
Next
From: Tom Lane
Date:
Subject: Re: Memory usage and pg_dump