PostgreSQL

• PostgreSQL Questions

• • External SQL functions exported by DLLs

    We have a few rather advanced calculation routinesdeveloped in C++. Currently we are using a Sybase ...

    By petersullvan

  • extracting x from a point(x,y)

    I have a table of points, actually zip codes and their points.If a point is an X, Y pair, how do I e...

    By jerryasher

  • Mailing list in French

    Le Mardi 19 Aot 2003 15:27, Erwan DUROSELLE a crit :> I'd be glad to join, but I couldn't find where...

    By guillaumelelarge

  • Database / SQL

    Does anyone know what this code does? It's from an .asp web page andthere are things being call...

    By shap

  • Mail test

    --------------------fred.brown@maps.lss.bc.cawilf.tannenbaum@maps.lss.bc.cadavid.mathews@maps.lss.bc...

    By fbrown

• • How to perform scheduled backups on OSX?

    Alas, it appears as though PGAdmin III does not have a scheduling component for backups...Any sugges...

    By mvreade, 1 Comments

  • book on advanced postgresql?

    Are there any books out there that are fairly current, but go into themore advanced aspects of Postg...

    By johnwells, 10 Comments

  • Recommended books about postgresql?

    I've bought 2 books about postgresql so far:1) Postgresql by Korry Douglas and Susan Douglas2) ...

    By edje, 2 Comments

  • Recomended FS

    Hi!> --Ursprngliche Nachricht--> Von: Shridhar Daithankar [mailto:shridhar_daithankar@persistent.co....

    By markuswollny, 1 Comments

  • " localhost" to address: Unknown host

    Hi All,When I try to execute any postgres command I get this error. I have stated the ips-daemon2, i...

    By sripathysena, 5 Comments

• PostgreSQL: is the Category's subject.It's has 75 questions,this is No.4 pages.
• Extract time from timestamp without time zone
• Hi all,I just want to extract time from a timestamp without time zone attribute on PostgreSQL 7.3.4-RH.Function date() [select date(now())] is working perfectly, but function time() [select time(now())] returns ERROR: parser: parse error at or near "now" at character 13.What is the tricky funct...
• jonjon, Sat, 13 Mar 2010 20:27:00 GMT, 362 bytes, 1 Answer
• Data Migration From Excel to PostgreSQL
• i need to migrate data from a excel to db using java codes. if there is any site where i can find a solution for this?...
• jagperam, Sat, 13 Mar 2010 15:29:00 GMT, 118 bytes, 1 Answer
• Books for PostgreSQL?
• The only problem with 'Practical PostgreSQL' is that it is rather out ofdate.It covers PostgreSQL up to 7.1. There have been a lot of advances since thensome that really need covering. (Functions returning record sets immediatelysprings to mind.)On the whole it is a good book, apart fr...
• benjaminjury, Sat, 13 Mar 2010 09:24:00 GMT, 2,430 bytes, 2 Answer
• bolb data type
• Hello,i have data in form of images which are in GB's,i need to store the extracted data from the images.This will required large fields size.I was thinking of Blob data type as we have inOracle. Do we have blob data type in postgreSQL, ifyes in which version.Thank'sGagan AnandIndia.__...
• gagananand, Sat, 13 Mar 2010 03:44:00 GMT, 729 bytes
• SQL help.
• Hello!I have a table with basically 1 column in it that I'd like to get statistics from from time to time. The table is called query_spy and its one column is queryid:queryid122510097232I'd like to get a report showing what percentage of the time each distinct queryid appears (in d...
• mpl, Sat, 13 Mar 2010 03:42:00 GMT, 1,041 bytes
• Extract date from timestamp
• hi I am having a startdate variable with timestamp datatype. I want to extract only the date from timestamp field...... Code: ( sql )SELECT extract('hour' FROM timestamp '2001-02-16 20:38:40')this query extracts hour from the input in the same way is there any option for extracting...
• priyan, Sat, 13 Mar 2010 03:38:00 GMT, 909 bytes, 2 Answer
• data migration
• I need a sample code to transfer data from table 1 of database 1 totable 1 (with more columns) of database 2.Please show me some hints or pointing me to the right direction.Thanks--Posted via http://dbforums.com...
• laguy, Sat, 13 Mar 2010 03:36:00 GMT, 296 bytes
• BLOB support
• Hi,I've got a large object question that I hope you guys can help with.I'm working on a server-side (C lang. functions) application that works with very large objects. A single object can hit several gigs. Working with large objects, I've noticed that they're stored in pg_l...
• slush, Sat, 13 Mar 2010 03:33:00 GMT, 1,917 bytes
• SQL Command - To List Tables ?
• On Wednesday, August 27, 2003, at 07:57 AM, Robby Russell wrote:> Peter Moscatt wrote:>> Is there a SQL command I can issue which will list all the TABLES>> within>> a database ?>>>> Pete>>> Well, when you are the postgres commandline client, you can typ...
• jeffreymelloy, Fri, 12 Mar 2010 12:14:00 GMT, 1,602 bytes
• "another command is already in progress" error (fwd)
• I am doing asynchronous sql calls using the postgres C library.After doing two PQsendQuery() calls, I get the"another command is already in progress" error.The two calls I am doing are an update, and then an insert, in that order.I am doing this for speed, since my program can't afford to w...
• pgsql_frenzy_org, Fri, 12 Mar 2010 11:59:00 GMT, 2,065 bytes
• Recovery after delete
• Hello!I accidentally deleted over 1,000,000 records from one table. I found axlog file containing those records but I don't know the structure ofthis file.Does anyone have a tool or a script enabling to recover data from thisfile?--Szymonusu _usun_ z adresu...
• szymon, Fri, 12 Mar 2010 05:16:00 GMT, 298 bytes, 1 Answer
• bolb data type
• Hello,i have data in form of images which are in GB's,i need to store the extracted data from the images.This will required large fields size.I was thinking of Blob data type as we have inOracle. Do we have blob data type in postgreSQL, ifyes in which version.Thank'sGagan AnandIndia.__...
• gagananand, Fri, 12 Mar 2010 02:20:00 GMT, 729 bytes, 2 Answer
• oracle error: Database or object is read-only
• we are trying to release data from a front end application using oracle client and are faced with this Error "Table (SCOTT.TESTINGDOCUMENT): Cannot update. Database or object is read-only. Probably lacking unique index.]"VERY VERY URGENTRegards,Dinesh Krishnan...
• dineshkrishnan, Fri, 12 Mar 2010 00:46:00 GMT, 296 bytes, 1 Answer
• BLOB, iBatis & PostgreSql 8.1
• Greetings!I got lost trying to save and read an image file from a db.I get file upload taken care of where a servlet populates a bean with the image file and other info,but I can't get to be written to the db.What's the best way to procede, starting with the bean? Would this be appropr...
• dbtomek, Thurs, 11 Mar 2010 23:24:00 GMT, 2,204 bytes, 3 Answer
• How to obtain the real problem that avoids postgresql service starting?
• Hi all,...I'd like to know where can I get information about what is happening topostgresql so it can't be started...all I get is:Starting postgresql service: [FAILED]Is there any log file, or a way to start the database with a kind of -v(verbose) option??Or maybe any configuratio...
• netto, Thurs, 11 Mar 2010 19:22:00 GMT, 448 bytes, 3 Answer
• Mailing list in French
• > I'd be glad to join, but I couldn't find where or how to subscribe...It's not yet posted on the web site, but you can subscribe by sending amail to majordomo@postgresql.org, leave the subject line blank and putin the body "SUBSCRIBE pgsql-fr-generale".Bye--FrancoisHome pag...
• francoissuter, Thurs, 11 Mar 2010 15:50:00 GMT, 756 bytes
• Extract Week problem
• Hello,I am using extract to retrieve the week of a certain date as follows..SELECT INTO extractweek EXTRACT( week FROM NEW.startdate );However, doing it this way does not suit my purposes since thestandard week starts with Monday. My weeks must start withSunday instead, and therefor it gives me...
• robertblixt, Thurs, 11 Mar 2010 09:29:00 GMT, 488 bytes
• Recomended FS
• > Theory vs. real life. In Theory, RAID5 is faster because less> data have> to be written to disk. But it's true, many RAID5 controllers> don't have> enough CPU power.I think it might not be just CPU-power of the controller. For RAID0+1you just have two disc-I/O per writ...
• markuswollny, Thurs, 11 Mar 2010 08:07:00 GMT, 1,235 bytes, 4 Answer
• Data partitioning?
• hi,I am becoming more and more convinced that in order to achieve therequired performance and scalability I need to split my data amoungstmany backend machines.Ideally I would start with about 10 machine and have 1/10th of the dataon each. As the data set grows I would then buy additional machin...
• psql_mail_freeuk_com, Thurs, 11 Mar 2010 08:06:00 GMT, 905 bytes, 1 Answer
• How to migrate Posgress SQL database to Microsoft SQL 2000
• How to migrate Posgress SQL database to Microsoft SQL 2000 with all primary keys and views?Is the function in Postgres SQL need to re-code in MSSQL 2000 manually?...
• ptmhki, Wed, 10 Mar 2010 12:28:00 GMT, 172 bytes, 3 Answer
• 1234