Search results for query: *

Well, the upper case function is working fine if it wasn't for the fact I work in Brazil and here the language is portuguese which has some characters that are not used in English, such as "ê", "á", "ú", etc. These kind of characters do not change to upper case when I use the upper case function...

I am having trouble to remember the solution of a simples problem. There is a condition you put on a select to bring only one specific tuple from a table or the whole table. Ex: select * from user where (ID_user = :iduser or BLABLABLA) The BLABLABLA part is the one I don't remember! The thing...

Well, I've having many issues with dump files which I've been able to solve with some help I got from here. Now my problem is to generate a dump file that folow the hierarchy of the constraints. The situation is that I have a script that generates the database and its constraints. The dump file...

Well, I was able to dump and restore a database, but my problem is that I want to fill up a new database with a old dump file records. I have grown the database table number and columns. The file I am trying to restore has data that is ment to be on a new production database, so I have cleared...

I dumped the database from the server and I am trying to set it up on another server by using psql command. Just like this: psql newdb > c:\dumpfile.dump The psql command is working. But whenever I do that the prompt stops answering instead of reading the file and generating the data. Any...