PostgreSQL Database Forum

Dear All, I have instaled PostgresSQL 8.2 in windows xp system.That windows xp system have a static ip.I already update that static ip in pg_hba.config files after stop start postgresql service.Still i can't connect the postgressql database from outside.How to solve this problem.Pls adice me.Advance thanks With Kindly Regards Siva

Here is a prototype statement, which if it worked would give me a desirable result. Unfortunately random doesn't exist as an aggregate function. The next best thing I can find that does work is the first and last functions, but they aren't as good. select id, test, random(result) from labs group by id, test In case some background...

hi I'm changind of BD from SQL to postgreSQL and I wanna know how to do this stored procedure in postgres create Procedure . As BEGIN Select * From Departamento END thx

Hi, I am new to psql so i am having a little trouble acommodating with the language. Here is the problem: I have created a small functions that returns true or false: CREATE OR REPLACE FUNCTION DriverLogin(VARCHAR, VARCHAR) RETURNS BOOLEAN AS ' DECLARE l_username ALIAS FOR $1; l_password ALIAS FOR $2;

Hi All, I am trying to connct to a serverless/embedded PostgreSQL database from a C# application using VS 2005. First of all, is this possible with PostgreSQL? I know this can be done with some other database providers (sqllite?). If anyone has connected to such a database using some other method/language I'd be greatful for the information. ...

Hi, How can I export some tables from Postgres to SQL scripts? I've tried the COPY...TO command but it's not really what I was looking for as it creates CSV files. Cheers, Matt

Hii all, im doin a vb 1.1 vs.net 2003 project where im trying to update the data from mysql to postgreSQL.... when im trying to click on update , im opening the connection of PostgreSQL using SSH(secure shell) Dim myPgrConnect As New NpgsqlConnection("Server=localhost; Port=8443; Database=dalitch_css; User Id=dalitch; Password=dfndev;...

Hi experts, I have a table: cod1 int, hours1 timestamp, cod2 int, hours2 timestamp,

Hello - I'm running PG 8.1 on Windows XP. I've installed the server to run as a service. The psql command fails to connect to the server, although I can connect with other clients. When I enter psql -d mydb -h localhost -U admin I get the following response: psql: could not connect to server: Connection refused (0x0000274D/10061) ...

hi all, Question: i have a table in a database of 6 columns and 630 rows.i want to add one new column to this table and also update this column starting from row 1 to row 630. System information: 1.Linux ac8d7f39.ipt.aol.com 2.6.9-5.ELsmp #1 SMP Wed Jan 5 19:30:39 EST 2005 i686 i686 i386 GNU/Linux 2. PostgreSQL 7.4.6 My trial: 1. i...

Hi I have to install PostgreSQL8.0 in a Solaris 10 machine. Somebody please explain what all are the steps needed. Please specify the command to find out whether PostgreSQL is installed or not in a Solaris machine Thanks in advance. Anand

How to implements storeprocedure in PostgreSQL?

hai this archulu, i have a doubt in Mod perl programing with pgsql; plz help to me in my project i am canducting exam to students, in exam result , 1=right anwer, 0=wrong answer. $id=4; $sth1=$dbh->prepare("select SUM(result) from result_master where exam_id = '$id' and result = '1' ") or warn "Erron in prepare statemt ".$dbh->errstr;...

Hello All, In database i am storing value in "2007-03-22 02:00:00-05" formate And from input i am taking start date in "2007-3-25" formate and end date in "2007-5-20" formate . Now what i want is i want to fetch all the records from the table which comes between this start and end date. Can anyone help me with this. Thank you Gurunath

somebody please help me.... i want to create function to count a number of mount between 2 date. in microsoftsql we can use datediff(month,fromdate,todate) , or in oracle we use monthbetween....what about in postgresql ? or somebody can write for me the function please ? thanks a lot....

Hi, do you know how to export a table in postgresql to an external file in csv or xls format? gem

hello everyone i want to use dblink functions to access a remote database bt i am not able to install those functions on my machine i am using postgresql 8.2 on windows XP machine can anyone tell me how to install those functions?? on internet i have found that you have to write a command like psql your_databse < dblink.sql

hi all I do'nt have to much idea about postgreSQL.I just want to know. Can we give the size for a particular table / database at the time of table / database creation by the command create table table_name / createdb database_name ? If yes how?. OR Is there any command or way to give the size of a table and database ? Thanks...

hello all I am just started migrated from WAMP to WAPP can any body tell me how to run postgreSQL from command prompt?? shoonya

I uploaded data in to postgresql using pdadminIII ,In one the fields called 'time' i want to store time as 24 hour format .Is there a way where i can convert time in to 24 hour format and store in the postgresql database?

Hi, I need to substract a variable hour from a timestamp in PostgreSQL 8.2, I think I can use the following sentence select '2007-05-14 12:36:47' + ('-5 hours'::reltime); I try that line in console and works fine for my purposes, but I'm having troubles turning the '-5' into a parameter for a plpgsql function. Do you have any...

how to get current date in postgresql?

Hello All One of our clients is at very initial stage of migration from SQL 2000 to PostgreSQL. It’s not been finalized and some research is going on. Since I am new to PostgreSQL, I don't have any knowledge about it. Can any one focus on migration difficulties from SQL Server 2000 to PostgreSQL? I know some of it can be Case Sensitivity,...

I am newbie in Postgre, and i must write function that retrieve number of rows in given table. How it can be done? Thanks preliminary Dimitar Smilyanov

Hello, i deleted few fields in a PostGreSql table. now i want recover them. how can i get them. ...das