Re: [GENERAL] Where do I enter commands?

On Sun, Oct 25, 2015 at 07:57:48AM -0700, David Blomstrom wrote: > 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

Re: [GENERAL] Where do I enter commands?

Hello David, This cookbook has worked for me for the last five years on Mac OS X, always and totally reliable up to incl. El Capitan and every intermittent release before. And most of all, it worked even as a repair measure. So if my server would stop working after a small Mac Os X update, I

Re: [GENERAL] Where do I enter commands?

On Sat, Oct 24, 2015 at 07:33:15PM -0700, David Blomstrom wrote: > It seems like a command-line tool would be > incredibly tedious when creating tables, modifying them, filling them with > data, etc. For whatever it's worth, I find quite the opposite: once you have the hang of the command line,

Re: [GENERAL] Where do I enter commands?

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

Re: [GENERAL] Where do I enter commands?

Since you are just starting, you should probably familarize yourself with how PgAdmin works with PostgreSQL. Therefore, it is best you refer to the documentation for PgAdmin. PgAdmin III http://www.pgadmin.org/docs/1.20/index.html I also suggest you obtain a copy of one, or both, of the

Re: [GENERAL] Where do I enter commands?

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

Re: [GENERAL] Where do I enter commands?

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

Re: [GENERAL] Where do I enter commands?

Wow, great tips; you answered a question I was about to post either here or on a forum. One question, though. Someone said when you add a new column in Postgre, it's appended to the end of the table. Does that mean that's where it has to stay, or can you rearrange columns, as in MySQL? On Sun,

Re: [GENERAL] Where do I enter commands?

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

Re: [GENERAL] Where do I enter commands?

> On Oct 25, 2015, at 3:21 AM, Joshua D. Drake wrote: > > I would ignore Rob, he obviously is suffering from a lack of coffee. Our > community always tries to help new users. It is great to see you here. > > Sincerely, > > JD > Always the best advice :) OK,

Re: [GENERAL] Where do I enter commands?

No problem. I'm pretty grumpy when people invade MY turf - biology and education reform. As a former Seattle teacher who spent sixteen years in the meat grinder before becoming a whistle-blower, I've seen it all - and I know it all. ;) On Sun, Oct 25, 2015 at 8:41 AM, Karsten Hilbert

Re: [GENERAL] Where do I enter commands?

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

Re: [GENERAL] Where do I enter commands?

On Sun, Oct 25, 2015 at 08:32:43AM -0700, David Blomstrom wrote: > Someone said when you add a new column in Postgre, it's appended to the end > of the table. Does that mean that's where it has to stay, or can you > rearrange columns No, unless you drop/re-create the table (manually or with

[GENERAL] Where do I enter commands?

I just installed PostgreSQL and started reading the tutorial @ http://www.postgresql.org/docs/8.0/static/tutorial-createdb.html and was snowed at square one. To create a database, I'm supposed to type the following command: $ createdb mydb But it doesn't say where I'm supposed to type it. When I

Re: [GENERAL] Where do I enter commands?

On 10/24/2015 7:33 PM, David Blomstrom wrote: I'd greatly prefer a GUI. It seems like a command-line tool would be incredibly tedious when creating tables, modifying them, filling them with data, etc. Thanks. normally, your application programs do the data filling part, manual data entry

Re: [GENERAL] Where do I enter commands?

On 10/24/2015 07:44 PM, David Blomstrom wrote: Hmmm...I have pgAdminIII. When I click on Server, there's no option to create a database. I would spend some time here: http://www.pgadmin.org/docs/1.20/index.html before going much further, just to get the gist of pgAdmin. In the meantime, you

Re: [GENERAL] Where do I enter commands?

Good tip; I can now see the database I created. Thanks. On Sat, Oct 24, 2015 at 8:20 PM, Adrian Klaver wrote: > On 10/24/2015 08:00 PM, David Blomstrom wrote: > >> "Is there a entry under Servers?" >> >> PostgreSQL 9.5 (localhost) - but there's a red X over it. >> > >

Re: [GENERAL] Where do I enter commands?

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. > On Oct 24, 2015, at 9:29 PM, David Blomstrom > wrote: > > Good tip; I can now see the database I created.

Re: [GENERAL] Where do I enter commands?

On 10/24/2015 06:21 PM, David Blomstrom wrote: I just installed PostgreSQL and started reading the tutorial @ http://www.postgresql.org/docs/8.0/static/tutorial-createdb.html and was snowed at square one. To create a database, I'm supposed to type the following command: $ createdb mydb But it

Re: [GENERAL] Where do I enter commands?

"Is there a entry under Servers?" PostgreSQL 9.5 (localhost) - but there's a red X over it. On Sat, Oct 24, 2015 at 7:52 PM, Adrian Klaver wrote: > On 10/24/2015 07:44 PM, David Blomstrom wrote: > >> Hmmm...I have pgAdminIII. When I click on Server, there's no option

Re: [GENERAL] Where do I enter commands?

On 10/24/2015 08:00 PM, David Blomstrom wrote: "Is there a entry under Servers?" PostgreSQL 9.5 (localhost) - but there's a red X over it. That means you are not connected to the Server. Right click on the entry and select Connect. It will probably ask for a password, which should be the

Re: [GENERAL] Where do I enter commands?

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

Re: [GENERAL] Where do I enter commands?

I'm on a Mac running OS X El Capitain. I think I installed PostgreSQL 9.5 after following the links to http://www.enterprisedb.com/products-services-training/pgdownload#osx I just learned about phpPGAdmin and installed it as well. But when I navigate to localhost/phppgadmin, I get a "not found"

Re: [GENERAL] Where do I enter commands?

On 10/24/2015 07:20 PM, David Blomstrom wrote: I'm on a Mac running OS X El Capitain. I think I installed PostgreSQL 9.5 after following the links to http://www.enterprisedb.com/products-services-training/pgdownload#osx Well the tutorial is geared to using the command line to run programs.

Re: [GENERAL] Where do I enter commands?

Hmmm...I have pgAdminIII. When I click on Server, there's no option to create a database. On Sat, Oct 24, 2015 at 7:37 PM, John R Pierce wrote: > On 10/24/2015 7:33 PM, David Blomstrom wrote: > >> I'd greatly prefer a GUI. It seems like a command-line tool would be >>

Re: [GENERAL] Where do I enter commands?

I'd greatly prefer a GUI. It seems like a command-line tool would be incredibly tedious when creating tables, modifying them, filling them with data, etc. Thanks. On Sat, Oct 24, 2015 at 7:28 PM, Adrian Klaver wrote: > On 10/24/2015 07:20 PM, David Blomstrom wrote: >

Re: [GENERAL] Where do I enter commands?

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