Dear Friend
I have some question related to postgresql frontend. I have develop postgresql web based database under linux environment and I use Gedafe as frontend and Apache as server.
and now i am trying to build my database under window, the problem is that Gedafe is not working in Window environment, so my question, is anyone know which frontend that i can use on window environment which is freeware like gedafe and may be...
bogie
Last Activity: Apr 15 '08, 08:45 AM
Joined: Aug 29 '07
Location: Germay
-
What is the best free Postgresql frontend available ?
-
Error restoring bytea from dump
Hello every one,
I have a problem to restore my postgresql dumpfile. I have a postgresql database 7.3.2 in a linux environment and i want to restore the dumpfile that i make from linux environment to the postgresql 8.1.11 in a window environment. I make my backup in a postgresql 7.3.2 in linux environment with the following command :
pg_dump -b -v -Fc -Z9 -U _postgresql -f istpdb-2007-08-09.psqldump istpdb
and i try... -
How to read the content of psqldump
Hello
I have some problem with psqldump. I need to read some table from my postgresql backup (psqldump file). is there any body can help me, how can i read this psqldump, or is there any way to transfer this file to text file or something so i can read the content of this file. can any body show me which command should i use ?, if there is an example it would be better. Thank you very much.
bogie -
Hi
Thank you very much for the advice, it works.
Best regards,
Bogie... -
HAlo
Thank you very much for your help, it works.
Best regards,
Bogie...Leave a comment:
-
Add not null column in a table
Hi again
I have another question, I would like to add NOT NULL column in my table. I have done like this :
ALTER TABLE patent ALTER COLUMN patent_pri_date SET NOT NULL;
but it doesn't work and give the following error :
ERROR: ALTER TABLE: Attribute "patent_pri_dat e" contains NULL values
is any body can help me how can i add NOT NULL column to my table ?, I use postgresql... -
Rules in Postgresql
Dear Postgresql forum,
I have some question related to the rules in postgresql. I have a table invention with the following rules
Rules : rule_invention_ insert,
rule_invention_ update,
rule_invention_ delete.
I need to know the inside of this rule, i mean how the relation and so on. Is there any command to see the inside of this rule ?
Please help me. Thank you... -
Hallo
Thankyou for replying my question, Continue with my problem : After I know the relation of the dependent object, what should i do to change my column data type in my table invention ?, Should I use the DROP ... CASCADE command to destroy the dependent object one by one ? and connected again to the new column after i drop the old column ?, or is there any other way, I mean an easy way to change my column data type without destroying...Leave a comment:
-
Cannot change column data type
Hello
I have some problem to change my column data type in my table property from character(15) to character(100). I use Postgresql 7.4.
The problem is I try to make new column with charcater(100) then i copy the data from teh original column to the new column, then i try to drop the column but i get the following ERROR : Cannot drop table invention column invention_cite because the other objects depend on it.
Is any...
No activity results to display
Leave a comment: