PostgreSQL Database Forum

dear all, i have an array which has some elements. I want to invert the sequence of elements.i.e i want that last number of array should become first number and vice versa. thnx @rtist

Firstly, I am a complete newbie. I need to make the move from MS Access and am looking at either MySQL or PostgreSQL. However I cannot get postgresql to install. I get the following error message. "failed tocreate process for InitDB. Access is denied." I have searched for and read a lot of information, I have set permissions and created users,...

Hi All How to create a multiple coulmns inside a table in postgres database. For illusturation i have shown below ,how to create a table like this (below) in postgres database. Main Column | second column | | | A| B | | C | D | | | | | ...

Hi, i need a help i have a trigger that fires on insert and cols function X, in function X a need to update 3 columns of a table like col1 = (select a from table where id = NEW.ID), col2 = (select b from table where id = NEW.ID), col3 = (select c from table where id = NEW.ID) i wondering is there some posibility to update all this cols with 1...

Hi All Can anybody tell me like how to tell make a copy of data into RAM from hard disk for faster accessing of data?? My Postgres database and its contents(databases,tables are sitting in Hard disk) i would like to make copy for table_1 and store it in RAM. How to do that ? are there any commands for doing that ? Thanks in Advance

hi i am beginner and i want to know more about nesting of joins in postgres so please can any one help me.

Can anyone give hints of how to do the PostgreSQL DB install as easy as possible for customer on Windows (what kind of programs to use etc) .

Hi, Can anybody help me by letting me know how to increase the cache size of the postgreSQL server. as i am very new to using postgreSQL,i have no clue how to do so. Thanks and Regards, Hitesh Sethi

Hello, this is my first post, I´m new in C# and i´m developing a capture for a test helth for babies (tamiz), I´m making a capture screen with text box and checkbox. For databinding textbox I don´t have problems with this... DS = new DataSet(); pgDA.Fill(DS,"miCedula"); cone.Close(); tb_folio.DataBindings.Add("text",DS,"miCedula.folio");...

Hi All Are the SQL commands same for both mysql and postgres ? I am working on Postgres and i am getting syntax errors while using commands from Solaris 10 interactive terminal. can any one suggest link for sql commands for postgres database with syntax. Thanks Pradi!

hi all, I have a table common_memory_4_memory it has five columns which are: freememory usedmemory, totalmemory, sourcekey(machine IP(name)) and the timestamp i want to get the newest record for a specific machine using the timestamp column sample: 174156;"machine2";1166200260 173776;"machine2";1166200320 161704;"machine3";1166200380...

create database test if not exists. Someone know how to do this in postgreSQL?

Hi all... i have two tables roads and routes. 1) roads table which have following columns...... id, start_point, end_point, length.................. it looks like this id + start_point + end_point + length 1 + 20 + 30 + 10 2 + 12 + 40 + 25 3 + 35 + ...

Hii All I need to write DDL statements in function, as we used to do in Oracle with EXECUTE IMMEDIATE command. Is there any way we can do this. Regards Sarabjeet

Dear All, Hw to use the replication concept in postgres sql.Pls help for me. With Regards Siva

Hii All I need to write include DDL statements in function, as we used to fo in Oracle with EXECUTE IMMEDIATE command. Is there any way we can do this. Regards Sarabjeet

Hi all, im beginner to restoring dump files and postgresql as well so hope u could bear with me.! :D i have these dump files and i've been working on restoring everything in it. i've tried this command : psql -U postgres dbname < data.dump : the tables were restored wihout any data inside it. does anyone know how I could fix this? :D

Hi! I have a table named sales with the columns date (timestamp) and price (bigdecimal or something). I want to get the sale for each day (the sum of ‘price’ for all the rows with the same ‘date’). Like: 2006-10-10, 17 sales, 1500.00 $ 2006-10-11, 15 sales, 1400.00$ etc… This is how I try to do it: SELECT to_char(date, 'YYYY'),...

Hi Everybody Can anybody help me where i can open source for postgre sql that is compatiable for Soalris 10 OS.and how to install the same after downloading , As I am new to this Database related stuff please help me out. I searched in various sites I am getting postgre sql databse that is compatiable for windows(.msi).

Hi All there..... i m stuck at a point... and want a tip to solve the problem. i have one table steets which has two columns........ id as Pkey and names. i have another table city_route which has two columns...id and route... id: serial and Pkey route: array which contains streets id from street table.... i want to write a query and use...

Hello, I have a quick little question about the MySQL-command LEFT(columnName,int). My question is if there's a counterpart in PostgreSQL for this command and what it is? What I want to do is take the first specified amount of signs in a text-column and print them out. For example: Instead of printing out all information in a...

I want to delete a schema but first i want to know if it exist? What can i do? C U

US Based Internet development company seeking to establish an ongoing relationship with one programming team. You must be able to develop database driven sites from scratch. Experience in as many of the following areas as possible is needed particularly PHP, ASP, Mysql, PostgreSQL & SQL Server. Flash Actionscripting an added plus. * Adobe...

hi iam a new member and i need a help in my porject i need to Know how can I calculate the size of DB ,meaning caculaste the size of each table? also I need to know if the size of the database H/W is dependent or S/W is the dependent one or both are ? and when the DB is transferred from one computer to another does its size change? I...

People, I have an old (php3?) script which does CRUD over a mySQL db. I've upgraded to php5 and PostgreSQL (on Linux), and the script bombs (multiple errors). I'm working through it at the moment, but it's slow going. I have "list display" and "editable" working, but the DB write is not working nor is it posting an error. Are there any...