| |
thread by: artistlikeu |
last post Jan 2 '07 by: artistlikeu
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
|
thread by: bastech |
last post Jan 1 '07 by: bastech
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,...
|
thread by: Pradeep83 |
last post Dec 29 '06 by: michaelb
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 |
| | | | ...
|
thread by: gev |
last post Dec 29 '06 by: michaelb
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...
|
thread by: Pradeep83 |
last post Dec 29 '06 by: michaelb
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
|
thread by: sowmyaraman |
last post Dec 27 '06 by: michaelb
hi i am beginner and i want to know more about nesting of joins in postgres so please can any one help me.
|
thread by: DABE |
last post Dec 22 '06 by: michaelb
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) .
|
| |
thread by: hitz2win |
last post Dec 22 '06 by: michaelb
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
|
thread by: novato |
last post Dec 21 '06 by: novato
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");...
|
thread by: Pradeep83 |
last post Dec 21 '06 by: bplacker
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!
|
thread by: kirara |
last post Dec 21 '06 by: kirara
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...
|
thread by: olav78 |
last post Dec 19 '06 by: michaelb
create database test if not exists. Someone know how to do this in postgreSQL?
|
thread by: artistlikeu |
last post Dec 18 '06 by: artistlikeu
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 + ...
|
thread by: sarabjeethanspal |
last post Dec 17 '06 by: michaelb
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
|
thread by: varathasiva |
last post Dec 15 '06 by: sarabjeethanspal
Dear All,
Hw to use the replication concept in postgres sql.Pls help for me.
With Regards
Siva
|
| |
thread by: sarabjeethanspal |
last post Dec 15 '06 by: sarabjeethanspal
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
|
thread by: chenert |
last post Dec 15 '06 by: sarabjeethanspal
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
|
thread by: olav78 |
last post Dec 14 '06 by: olav78
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'),...
|
thread by: Pradeep83 |
last post Dec 13 '06 by: michaelb
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).
|
thread by: artistlikeu |
last post Dec 13 '06 by: artistlikeu
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...
|
thread by: Paks |
last post Dec 12 '06 by: Paks
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...
|
thread by: peperoni |
last post Dec 11 '06 by: michaelb
I want to delete a schema but first i want to know if it exist?
What can i do?
C U
|
thread by: WH |
last post Dec 11 '06 by: WH
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...
|
| |
thread by: The Angel |
last post Dec 11 '06 by: michaelb
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...
|
thread by: RickmanCR750 |
last post Dec 11 '06 by: RickmanCR750
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...
|