Aaron Roberson wrote:
>
> pgAdmin III comes installed out of the box with PostgreSQL and I
> cannot figure out how to create tables using it either. At least in
> phpPgAdmin I can write SQL directly to create tables, but phpMyAdmin
> has UI features for creating tables.
> 
> I would prefer using phpPgAdmin since I am so familiar with
> phpMyAdmin. However, if I went to work for a company that used
> PostgreSQL with anything other than PHP I could bet that they wouldn't
> use phpPgAdmin.

You should give the command line client (psql) a try. A command line client may 
sound archaic, but it offers some pretty nifty advantages:
- you can run it over a remote shell;
- it can do anything a GUI can, and some things a GUI can not;
- you keep up to date with your SQL;
- it is incredibly feature rich (inline help, tab auto-complete, statement 
history etc.).

Especially the tab auto-complete is a great feature. You just type the first 
few characters, press tab and the client completes it for you. Very similar to 
how tab auto-complete works in the Windows or Unix command line, it saves you a 
ton of typing and you don't have to switch between keyboard and mouse all the 
time as you have to do in a GUI.

Jochem

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:263691
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Reply via email to