Re: Where do I enter commands? - Mailing list pgsql-general

On 10/25/2015 07:57 AM, David Blomstrom wrote:
> It's hard to imagine creating a table with a command-line tool - in the
> step-by-step process I use with phpMyAdmin, that is. If you can learn
> the proper syntax for creating a table and put together a script for a
> generic table that you can easily modify, then maybe it would be a lot
> easier with a command-line tool.
>
> In phpMyAdmin, I've become accustomed to simply copying existing tables,
> then adding, deleting and renaming columns as needed.

In psql:

test=> CREATE TABLE orig_test(id integer, fld_1 varchar, fld_2 boolean,
fld_3 numeric(7,3));
CREATE TABLE

test=> \d orig_test
Table "public.orig_test"
Column | Type | Modifiers
--------+-------------------+-----------
id | integer |
fld_1 | character varying |
fld_2 | boolean |
fld_3 | numeric(7,3) |

test=> create table cp_test AS select * from orig_test ;
SELECT 0

test=> \d cp_test
Table "public.cp_test"
Column | Type | Modifiers
--------+-------------------+-----------
id | integer |
fld_1 | character varying |
fld_2 | boolean |
fld_3 | numeric(7,3) |

test=> alter table cp_test add column fld_4 date;
ALTER TABLE
test=> \d cp_test
          Table "public.cp_test"
  Column |       Type        | Modifiers
--------+-------------------+-----------
  id     | integer           |
  fld_1  | character varying |
  fld_2  | boolean           |
  fld_3  | numeric(7,3)      |
  fld_4  | date              |

One note, in Postgres new columns will always be added to end of table.

>
> 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. The community seems painfully small compared to MySQL, and
> there are less online resources. But I'm guessing that will change in
> the coming years. I remember when CSS was a strange, foreign thing. ;)

Last time I there was a count on the people on this mailing list I
remember a number of 33,000-34,000.

>
> On Sun, Oct 25, 2015 at 6:28 AM, Adrian Klaver
> <adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>> wrote:
>
>     On 10/24/2015 09:19 PM, David Blomstrom wrote:
>
>         I'm a writer. I studied programing and MySQL so I could create
>         websites
>         that I can publish my articles to. I don't have time to keep up
>         with the
>         endless technology - MySQL, PDO, stored procedures, PHP, JavaScript,
>         JQuery, and on and on - especially when I have to work for a living.
>         I've been using MySQL for years, so I'm familiar with it. It
>         therefore
>         makes sense for me to find a GUI as similar to MySQL as possible.
>
>         With phpMyAdmin, I can easily create, modify, copy and migrate
>         tables
>         between databases. If that can be done as easily with a
>         command-line-tool, even after surviving the learning curve, then I'm
>         interested. But it's really hard to imagine how that could be.
>
>
>     pgAdmin will allow you to do those things. phpPgAdmin also, though I
>     have never used it, so I can not be of much help there. The
>     predominate command line tool folks are referring to is psql:
>
>     http://www.postgresql.org/docs/9.4/interactive/app-psql.html
>
>     For dumping databases or their contained objects there is pg_dump:
>
>     http://www.postgresql.org/docs/9.4/interactive/app-pgdump.html
>
>     for restoring non-plain text dumps there is pg_restore
>
>     http://www.postgresql.org/docs/9.4/interactive/app-pgdump.html
>
>     for plain text dumps just use psql.
>
>     These three programs will cover most of your use cases. The benefit
>     to using these tools is that you end of working with scripts that
>     then can be put under version control. Takes a little bit of time to
>     set up but the payoff is worth it for anything above the really
>     simple level.
>
>
>         Thanks for the tips.
>
>         On Sat, Oct 24, 2015 at 9:07 PM, Adrian Klaver
>         <adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>
>         <mailto:adrian.klaver@aklaver.com
>         <mailto:adrian.klaver@aklaver.com>>> wrote:
>
>              On 10/24/2015 08:52 PM, Rob Sargent wrote:
>
>                  ok. now who has the url to the pithy
>                  heres-why-you-/really/-want-the-command-line.
>
>                  It distills to something about actually knowing what
>         you’re doing.
>
>
>              Everyone has to start somewhere. The point is get someone using
>              Postgres in manner they are comfortable with, then they can
>         start
>              exploring the possibilities. I personally find the command
>         line more
>              productive, but there is a learning curve.
>
>
>
>
>
>              --
>              Adrian Klaver
>         adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>
>         <mailto:adrian.klaver@aklaver.com
>         <mailto:adrian.klaver@aklaver.com>>
>
>
>
>
>         --
>         David Blomstrom
>         Writer & Web Designer (Mac, M$ & Linux)
>         www.geobop.org <http://www.geobop.org> <http://www.geobop.org>
>
>
>
>     --
>     Adrian Klaver
>     adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>
>
>
>
>
> --
> David Blomstrom
> Writer & Web Designer (Mac, M$ & Linux)
> www.geobop.org <http://www.geobop.org>


--
Adrian Klaver
adrian.klaver@aklaver.com