Working with Postgresql

[Hyperblaze]

I'm creating a table in postgresql using phpPgAdmin (ever heard of it?)

If there is another open source php project with is better to use for working with postgresql, feel free to let me know 😀

On table creation I'm attempting to create a column which is the equivlant of varchar in mysql. I've researched the web and found out that varchar also exists in postgresql, but for some odd reason it just is not in phpPgadmin when selecting type of column.

Is it under a different heading?

 

[kamper]

Anything wrong with the non-web gui admin client? I've always found it to be quite useable, although I've usually done table creation through scripts and hence the commandline.

 

[Hyperblaze]

Originally posted by: kamper
Anything wrong with the non-web gui admin client? I've always found it to be quite useable, although I've usually done table creation through scripts and hence the commandline.

i don't know enough about postgresql to preform this all on command line yet.

There is a gui non-web version for x-windows, but i do not have x-windows installed on there. (would hate to install it just for one gui app)

 

[cubby1223]

You can try text instead of varchar, essentially does the same thing, but does not have a specific size limit. Can you enter a query manually without using drop downs? The usage should just be like varchar(5) to create a max 5 character field.

EDIT - if you can create the table without the varchar column, then it's just this sql command to add it:

ATLER TABLE tablename ADD COLUMN columnname varchar(5);

 

[kamper]

Originally posted by: Hyperblaze

Originally posted by: kamper
Anything wrong with the non-web gui admin client? I've always found it to be quite useable, although I've usually done table creation through scripts and hence the commandline.

i don't know enough about postgresql to preform this all on command line yet.

There is a gui non-web version for x-windows, but i do not have x-windows installed on there. (would hate to install it just for one gui app)

I seem to remember running it just fine out of the box on windows. Are we both talking about http://www.pgadmin.org/ ?

 

[Hyperblaze]

Thanks guys for your feedback. I'll try out more stuff and let you know how things go.