PostgreSQL Database Forum

Hi there, i'm busy with quite a large project using PostgreSQL. Now the problem is that one of our data tables seems to have been corrupted. I cant open the table certain SQL queries like select does return results but the returned results are selective meaning that only certain fields are returned and not every thing that you asked for. Is...

Hi all, Iam struck with one of the problem with postgres. Please help me out.... Iam trying to connect to connect to postgres database on remote machine with the IP address 10.2.1.4. Iam unable to get connected. below is my script. <?php $connection_string = 'DRIVER={PostgreSQL};SERVER=10.2.1.4:5432;DATABASE=Admin';

i am writing a function. my function gives multiple redords as result. when i add a check (bool) constraint and call this function in check, error mess comes that sql query gives multiple records.Yes logically it should extrract one record for boolean check. Any hint ... or i have to add a loop in function so that my sql query must return single...

I had made a database table of a persons profile. now I want to show the data to the user in form of a editable html form so that the user can update his profile and database table should also be updated and the html page related to the html form should also be updated

Hi All, I am wondering if there is a way to create a linked table in postgresql. I have a table in a DB i created and i want the table in a second DB, linked, so that any mods to one table apply to both. Any help is appreciated.

hi can ne1 plz guide me as to which interface is best for posgresql. i have started using posgrsql recently. i am making a biological database which has a frontend allowing the user to select various option like login, password, organism to view , select perticular option etc., and the backend as postgresql where all the process of submission...

hi all, how to insert 60million rows to the postgres datase. i want to increase the performance as it is taking 1min to insert every 1000rows. is there any easier way to do it. thanks in advance.

Hi All, At my company we have 5 FreeBSD servers around Australia, some on very low bandwidth connections. 1 Server (in Perth) has the Postgres Database, all other server just make calls to the database through a web server. Is it possible to set up data compression between the servers through the network, so all postgres data on port 5432 is...

Hi, is it posible to execute script from file within function (sql or pl/sql or ...)

hi dear experts, pls help. i was asked by my boss to limit the size of the database to 10MB per account holder. how can this be done? any code will be greatly appreciated...im using PHP and postgre database pls help thank you...

dear all i am using postgresql data base.... is it possible to write a subquery in inside the main query in python program.... for example something like this..... courses = db.query("select course_id, student_id, select course_coordinator from teachers join course on teacher.course_id=course.course_id, start_date from school)" subquery...

I would like postgres to send a message via a socket to another machine if a certain table is updated or changed...Is this possible? If so please guide... I'd rather not have the c application on another machine have to continually poll for changes... Plz help

Dear all, can any one solve this problem..... i have a table name as course which has following columns cid as serial (PK) course_id as int student as int4 and course table looks like this

how to insert image in a table in pgsql database.

i have query result (25) rows. can i insert them into an column (array) in a table. thnx

Hi, I'm currently following the book: Beginning Databases with PostgreSQL, From Novice to Professional with Postgresql-8.2.0-1 Chapter 4, page 76: Accessing You Data. Having followed the book's instuctions, I've set up two roles: One as 'Mikael' and another as 'Rick' (with Mikael having permission to create Db's and new roles and Rick only having...

can a table have username and password in pgsql database. If yes, How?

Hi all, can someone give me a hint for one problem... i have a linestring. it has start point coordinates, end point coordinates and of course length and each point has (x,y) coordinates pair. these x,y coordinates are stored in a separete table for every start and end point respectively . let suppose that length of linestring is 500 meter. i...

hi can ne1 tell me advantage of postgresql over ms access and limitation of postgresql over MS access. plz help thanx neha

hi iam running this simple query using table,column aliases SELECT T1.student S1,SUM(T1.mark)"TOTAL MARKS" FROM ALLMARKS03 T1 GROUP BY T1.student where T1 table alias s1 column alias,ALLMARKS03 is table name ERROR: parser: parse error at or near "S1" at character 18 if i dont use column aliases just table aliases then fine otherwise above...

i have created a table now I want to give login password to the table so that only the person having login password can access it. how can I do it?

Hi All Problem : I am unable to retrieve the data from the table in postgres database using C application which i have written in solaris os. Query: How to check whether connection is there between postgres database and C application(which we have written for accessing the database) ? My code is comiling successfully if i run it then...

Dear all, i have a column with data type array with variable size ...... e.g number = i want to access the last element of this array....... i accessed the first element by following statement.... select * from student where number = this worked fine....

hi, i have home work to build a database. there is a rule stated if airplane removed from database, it won't removed flight schedule that use the airplane. i have made the DDL, but it's not work create table airplane( no_airplane serial primary key, brandvarchar(20) not null, model varchar(20) not null, year_madechar(4) not null,...

I have a table (which i cannot modify) where date and time fields are stored as VARCHAR. But i have to cast these fields into timestamp. My requirement is like, timestamp (select date, time where max(timestamp(date,time)); How to do this in postgres?