Hi,
i have solution for this
run this query
ALTER TABLE tableName ALTER COLUMN columnName TYPE
newdatatype;
Pramod Gautam
Last Activity: Jul 1 '08, 07:02 AM
Joined: Mar 11 '08
Location: Nagpur
-
I think , this is not a problum of database. Because when anyone close thier application cthe connection betwwen that database also close automatically. One more way for close datbase that is you run "exit" query from your application. I think this will help you.Leave a comment:
-
you have to need use subquery
use this
insert into tableName values((select Current_time as columnName));Leave a comment:
-
Hi, I am using Debian etch with postgresql database. I used this procedure for start postgre database on my terminal
follow this procedure
1. open root terminal
2. type=> su - postgres
3.psql -l (it show default database)
4. If you want craete new database type=> createdb mydb
5. After that enter your database by usesing=> psql mydb
6.use SQL queries
7. use \q to quite your database...Leave a comment:
No activity results to display
Leave a comment: