Hi Aaron, We use phpPgAdmin extensively. First, just to cover the bases, you will need to create your database first. Each PostgreSQL installation allows you to create any number of individual databases.
After you've got your database created, you can create a table within that database by clicking the "+" sign next to it. This will open up the "schema" tree. After the schema tree is open, you should see a "public" schema. If you are not familiar with schema's, just think of them as databases within a database. That's not technically what they are, but it will give you the basic idea. Click on the "+" sign next to the default "public" schema. This should several more options available to you. On my screen, I see "tables", "views", "sequences", "functions", and "domains". If you've ever used MS SQL Server Enterprise Manager, this should look somewhat familiar to you as the layout is similar. Click on "Tables", and the main screen will change to display your current tables. At the bottom of the main screen, if the user your are logged in with has permission, you will see the "Create Table" link. Hope this helps! -- Warm regards, Jordan Michaels Vivio Technologies http://www.viviotech.net/ Blue Dragon Alliance Member [EMAIL PROTECTED] Aaron Roberson wrote: >>It has been a while since last time I used PostgreSQL. But this could be >>worth a try: >>http://www.pgadmin.org/ > > > 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. > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:263683 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
