From: | Andrew Sullivan <ajs(at)crankycanuck(dot)ca> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Where do I enter commands? |
Date: | 2015-10-25 15:10:30 |
Message-ID: | 20151025151029.GA1228@crankycanuck.ca |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Sun, Oct 25, 2015 at 07:57:48AM -0700, David Blomstrom wrote:
> In phpMyAdmin, I've become accustomed to simply copying existing tables,
> then adding, deleting and renaming columns as needed.
Oh! Interesting. I suspect you're actually _undermining_ your
ability to use the database (because often when you copy a table it's
a sign that you're using the database like a spreadsheet, and you're
giving up a lot of functionality that way).
But, suppose you're wanting to do that, then here's the easy way to do
it:
--- if you want the same table structure without the data
CREATE TABLE newtable AS SELECT * FROM oldtable WHERE 1=0;
-- if you want the same table with some data
CREATE TABLE newtable AS SELECT columns, you, want, in, order
FROM oldtable
[WHERE conditions];
If you want only some columns or new order or something, the WHERE
clause in the latter statement should be 1=0. It makes a null set
always. Handy trick.
> I can see PostgreSQL is going to have a learning curve - hopefully shorter
> than the years it took me to learn MySQL - but it looks interesting.
It should be much easier. You have the basics from MySQL already.
Consistency and rigour are the changes ;-)
A
--
Andrew Sullivan
ajs(at)crankycanuck(dot)ca
From | Date | Subject | |
---|---|---|---|
Next Message | Adrian Klaver | 2015-10-25 15:13:13 | Re: Where do I enter commands? |
Previous Message | David Blomstrom | 2015-10-25 14:57:48 | Re: Where do I enter commands? |