Just installed postgres in a windows box, 8.3.14开发者_开发问答-1, started up pgAdmin and it is in my local language (PT) instead of english like I wanted.
I am using pgAdmin for my Postgres 8.4 database and I was wondering where (any table/schema/etc. ?) may I find a list of currently used temporary tables? I assume there has to be a place where I can f
I want to be able to SELECT the code of a Function. When I try this Query: select开发者_StackOverflow中文版 prosrc from pg_proc where proname = \'my_proc\'
Okay, I appreciate that the question is a tad vague, but after a day of googling, I\'m getting nowhere, any help will be appreciated, and I\'m willing to try anything.
I\'m trying to create a function in Postgres 8.4 using pgAdmin and I have the following code CREATE OR REPLACE FUNCTION spcwriteperson(IN fname varchar(20)开发者_如何转开发)
Why pgAdmin creates a new pgAgent job only on the Postgres db even though I开发者_JAVA技巧 specify the setting on another db?Because the administration of pgAgent is stored inside the schema pgagent i
I\'m having trouble connecting to the database for my Rails app using pgAdmin. I have the server running and I believe that my server properties are correct in pgAdmin. Here\'s what I have in pgAdmin
i have installed postgres 8.3, i entered test as the password while the installation...my problem is that each time i try to access the local database...each time i enter the password...it say databas
开发者_开发知识库 As it currently stands, this question is not a good fit for our Q&A format. We expect answers to be supported by facts, references,or expertise, but this question will likely
I\'ve changed column length manually in my previous database. But after creating new database via HQL it\'s creating varchar(255) and I need to make it longer.
加载中,请稍侯......