[GENERAL] MS-SQL2PostgreSQL

Dear All,I have a sql MS-SQL script, i would like to run the script in postgresql. Is there a MS-SQL2PostgreSQL converter available or does one has to go trouble shooting line by line changing data types etc one line at a time??!!! Thanks,Hrishi

[GENERAL] Question about selecting rows

Hi All,I have a question about selecting rows, my table has 20,000 rows, i want to look at rows 5000 to 10,000.How does one use the select statement in this case since i don't have a specific case to use where?! Thanks in advance.Hrishi

[GENERAL] OpenSuse10.0 and postgresql

Hi All,Can somebody please tell me where i can find rpms for postgesql on OpenSuse 10.0?Sincerely,Hrishi

Re: [GENERAL] OpenSuse10.0 and postgresql

Hi All, In downloaded the rpms and installed rpms. Could someone help me what to do next?! The 8.0 documentation talks about installation from source code! Thanks, Hrishi

Re: [GENERAL] OpenSuse10.0 and postgresql

: On Saturday 18 March 2006 11:44 am, Hrishikesh Deshmukh wrote: Hi All, In downloaded the rpms and installed rpms. Could someone help me what to do next?! The 8.0 documentation talks about installation from source code! Thanks, HrishiSuSE puts their documentation for packages under /usr/share/doc

[GENERAL] User tables

Hello All,Suppose there 3 users red, green, blue. How can the user green know what tables he has created?!From psql command line \dt lists every table in the DB!!!Thanks in advance.Hrishi

[GENERAL] PgAdmin3 for Suse AMD64

Dear All,I have two questions:1) One can used select * from pg_group to get list of groups BUT how does one get group membership say for this example find users who are under the group sales?! booktown=# SELECT * FROM pg_group; groname | grosysid | grolist+--+-

[GENERAL] Question

Hi All,I am trying to create a simpel table to handle geneId and productId but the data file which i want to read in has for some genes more than one productId ex:GeneId | ProID1 /// ProID2 /// ProID3Now how does one input the same information without having GeneId listed in the table more than

[GENERAL] RAID 5 and postgresql

Hi All,Are there any pointers for RAID tuning (RAID5) with PostgreSQL 8.0?!Thanks,Hrishi

[GENERAL] Reports and postgres

Dear All, Sincere apologies if this is a re-post. Is there a good reporting tool which will let me generate scatter plots/ histograms say for a query like select col1, col2, col3,.col51 from table idsvsgenes where pid=1000_art; I have lots of data in a table and generating scatterplots/

[GENERAL] Postgresql 8.0 and XP

Hello All, I have a dump file using phpPgAdmin in sql format. I took this file and then using PgAdminIII ran the sql script on a Windows XP machine. Though i don't see any errors i can't see the database with tables being created!!! This approach had worked in the past for me on a Win 2000 box.

[GENERAL] Schema overlay question

Hi All, A simple question to the list. We are designing a database, the database has three major components (each component with 4-8 tables) two components are ready, is it possible to 'overlay' the third one later? or Do i have to drop all the components (along with data!!!) and then add the

Re: [GENERAL] Schema overlay question

, 2005 at 05:28:11PM -0400, Hrishikesh Deshmukh wrote: We are designing a database, the database has three major components (each component with 4-8 tables) two components are ready, is it possible to 'overlay' the third one later? or Do i have to drop all the components (along with data

[GENERAL] Suse9.3

Hi All, Has anybody used postgresql 7.4.7 on Suse 9.3? If yes how easy or difficult was it to install? Any pointers/suggestions are welcome. Thankyou Hrishi ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

[GENERAL] OIDS

Hi All, I have 7.4.7 version, my question is what are OIDS user for? What can one do with it! Thanks, Hrishi ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

[GENERAL] Reporting tools

Hi All, Are there better open source reporting tools than openrpt, agata? Thanks, Hrishi ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])

[GENERAL] postgres and xml

Hi All, Is there a way that makes it possible to export sql query results as a xml file? I use postgres 7.4.7 on a debian system. Do i need any packages to export query results as a xml file if its possible? Thank you Hrishi ---(end of

[GENERAL] postgres and ggobi/xgvis

Hi All, How easy or difficult is it to get ggobi/xgvis working with postgresql?! Is it possible to write a query and send the output straight to ggobi/xgvis without much work? Any pointers. Thanks for your help. Hrishi ---(end of broadcast)--- TIP

[GENERAL] Question: migrate

Hi All, I have a huge database working on a debian linux machine, this machine is going to get a hard drive wipe and new OS. I have another debian linux machine (exact hardware + software). Is there a way to get database migrated from machine 1 to machine 2 without much work? Anxiously waiting

[GENERAL] Just a crazy idea!

Is it possible to connect a DB in Postgresql to a DB in MySQL! I know its a crazy idea! H ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq

Re: [GENERAL] Just a crazy idea!

Of Hrishikesh Deshmukh Sent: Thursday, May 26, 2005 2:05 PM To: Postgresql-General Subject: [GENERAL] Just a crazy idea! Is it possible to connect a DB in Postgresql to a DB in MySQL! I know its a crazy idea! H ---(end of broadcast

Re: [GENERAL] Just a crazy idea!

indicate that i am not looney at all ;) Hrishi On 5/26/05, Dawid Kuroczko [EMAIL PROTECTED] wrote: On 5/26/05, Hrishikesh Deshmukh [EMAIL PROTECTED] wrote: Is it possible to connect a DB in Postgresql to a DB in MySQL! I know its a crazy idea! Why, of course. Been' doing that. All you

Re: [GENERAL] Just a crazy idea!

LOL..not looney! On 5/26/05, Matt Miller [EMAIL PROTECTED] wrote: On Thu, 2005-05-26 at 17:21 -0400, Hrishikesh Deshmukh wrote: I have a little schema in pgsql and some annotation in mysql; ... if i could make these two talk ... So the question and frankly i thought

[GENERAL] Postgresql 7.4.7 docs(PDF)

Hi All, If someone can email Postgresql 7.4.7 docs(PDF). It will be a big help. I am unable to get pdf docs for this version on debian system. Please help. Thanks, Hrishi ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [GENERAL] Postgresql 7.4.7 docs(PDF)

: Hrishikesh Deshmukh wrote: Hi All, If someone can email Postgresql 7.4.7 docs(PDF). It will be a big help. I am unable to get pdf docs for this version on debian system. Please help. Available from here: http://www.postgresql.org/docs/manuals/ See the links on the right-hand-side

[GENERAL] bulk loader

Hi All, Is there a bulk loader in postgresql with which one can read in say a tab delimited format text file. Before one does all one has to do is create the table with text file column names as attributes, once it is on DBMS world it will be a simple table (non-relational) Thanks, Hrishi

[GENERAL] perl and insert

Hi All, Anybody knows how to use perl dbi to read a file line by line and insert into db! The books which i have tell you exclusively on running queries. Thanks, Hrishi ---(end of broadcast)--- TIP 2: you can get off all lists at once with the

[GENERAL] Logs

Hi All, Where can i find more information on user actions, i.e. say a user logins in and does some querying via sql and then uses perl/c/c++ language to do some more querying. So how does postgresql keep track of user actions in a sequential order? Thanks, Hrishi ---(end

[GENERAL] Postgresql and logs

Hi All, My sincere apologies if this is a re-post. Where can i find more information on user actions, i.e. say a user logins in and does some querying via sql and then uses perl/c/c++ language to do some more querying. So how does postgresql keep track of user actions in a sequential order?

[GENERAL] Postgres and GnuPlot

Hi All, Has anybody tried using gnuplot to plot results from queries; there are some suggestions given in PostgreSQL Developer's Handbook but i have not any luck so far! Any pointers as how to send results from queries straight to a simple plotting utility (ex:gnuplot)! Thanks, Hrishi

Re: [GENERAL] Postgres and GnuPlot

surprising, if apache is looking for a null to see when stdout stops but I don't know how to get around that. On May 9, 2005, at 7:51 AM, Hrishikesh Deshmukh wrote: Hi All, Has anybody tried using gnuplot to plot results from queries; there are some suggestions given

[GENERAL] WHERE

Hi All, How can one use a table created for saving the results for a query be used in WHERE for subsequent query!!! Step 1) create table temp as select gene from dataTable1 intersect select gene from dataTable2; Now temp has been created, temp has only one column which has list of genes and

Re: [GENERAL] WHERE

Of Hrishikesh Deshmukh Sent: Monday, May 09, 2005 12:49 PM To: Postgresql-General Subject: [GENERAL] WHERE Hi All, How can one use a table created for saving the results for a query be used in WHERE for subsequent query!!! Step 1) create table temp as select gene from dataTable1 intersect

Re: [GENERAL] Data Modelling Tools

This is my favits just awesome... http://www.sqlmanager.net/ On 5/9/05, Mark Borins [EMAIL PROTECTED] wrote: Postgres Newsgroup, My company has been looking for a good database modelling tool for postgres and have yet to find something that completely satisfies our

[GENERAL] Functions!

Hi All, Can a query be cast as function: i have a query say like: select * from tableName where signal=2000 and signal =20 and flag=0; How can one say in a function generic tablename!! Thanks, Hrishi ---(end of broadcast)--- TIP 1: subscribe

[GENERAL] SQL History

Hi All, Does Postgresql have a sql history of queries run capability? Any ideas/pointers will be a great help. Could one capture the order and SQL queries run?! Thanks in advance and your help is appreciated. Hrishi ---(end of broadcast)--- TIP

[GENERAL] Visual Query Builder

Hi All, I have DB in Postgresql; is there a visual query builder? Thanks in advance. Hrishi ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

[GENERAL] PostgreSQL and Schema (pictures)

Hi All, I have a db in postgresql (Win, 8.0). Is there any software that i can use to connect to DB and get ER diagram(pictures) of the DB! Thanks, in advance. Hrishi ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send

[GENERAL] Views!

Hi All, I have 254 tables, i want to subset it in 237 and 17 tables?! Is creating views the answer?/ Is there a better way to subset them? Thanks, Hrishi ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [GENERAL] Views!

/docs/current/static/ddl-schemas.html Sean On Mar 29, 2005, at 8:27 AM, Hrishikesh Deshmukh wrote: Hi All, I have 254 tables, i want to subset it in 237 and 17 tables?! Is creating views the answer?/ Is there a better way to subset them? Thanks, Hrishi

Re: [GENERAL] Views!

-0500, Hrishikesh Deshmukh wrote: [rearranged] On Tue, 29 Mar 2005 09:01:24 -0500, Sean Davis [EMAIL PROTECTED] wrote: On Mar 29, 2005, at 8:27 AM, Hrishikesh Deshmukh wrote: I have 254 tables, i want to subset it in 237 and 17 tables?! Is creating views the answer

[GENERAL] Time Stamp

Hi All, I want to get a timestamp of the queries that i run! Is there a builtin command to do this/ does one need to write a function/stored procedure! Any pointers will help. Thanks, Hrishi ---(end of broadcast)--- TIP 5: Have you checked our

Re: [GENERAL] Time Stamp

Hi, I want to know how long did it take for my query to run! Thanks, Hrishi On Mon, 21 Mar 2005 15:57:38 +, Richard Huxton dev@archonet.com wrote: Hrishikesh Deshmukh wrote: Hi All, I want to get a timestamp of the queries that i run! Is there a builtin command to do this/ does

[GENERAL] Statistics with PostgreSQL

Hi All, Is there a way to simple statistics like mean/median/mode in PostgreSQL. I have tables like PsetID | IntensityValue. I want to find out mean (intensityValue) of some PsetID(s)?! Any urls/pointers/books would be a big help. Thanks, Hrishi ---(end of

Re: [GENERAL] GUI

Hi All, A question about joins i have 17 tables in my postgres-DB how does one perform a join on these many tables!!! :( Thanks, H On Tue, 1 Mar 2005 08:42:57 -0600, James Thompson [EMAIL PROTECTED] wrote: On Tuesday 01 March 2005 08:07 am, Hrishikesh Deshmukh wrote: Hi All, I want

Re: [GENERAL] GUI

Hi, I want to do a 17 table join! :( But a general idea will help. Thanks, H On Thu, 3 Mar 2005 16:56:13 -0500, Sean Davis [EMAIL PROTECTED] wrote: On Mar 3, 2005, at 4:36 PM, Tino Wildenhain wrote: Am Donnerstag, den 03.03.2005, 14:35 -0500 schrieb Hrishikesh Deshmukh: Hi All

Re: [GENERAL] GUI

Hi All, I want to spend less time coding and more time running queries against the DB which i am building. What about QT from TrollTech!! Can that be used to whip up gui real fast! Dreamweaver? Hrishi On Tue, 01 Mar 2005 07:55:04 +, Richard Huxton dev@archonet.com wrote: Hrishikesh

[GENERAL] GUI

Hi All, My sincere apologies if this is not the right list. I want to build a GUI for postgres DB, is there any toolkit available which allows to whip up a GUI real fast? General features for the GUi are like select a file to upload, login for DB Thanks in advance. HD