[GENERAL] How to retrieve Comment text using SQL, not psql?

2015-05-30 Thread Bob Futrelle
for every article.' - Bob Futrelle

Re: [GENERAL] Re: Stuck trying to backup large database - best practice? How about a cloud service?

2015-01-13 Thread Bob Futrelle
Many worthwhile things cost money. I never suggested you wouldn't have to pay. - Bob On Tue, Jan 13, 2015 at 12:27 AM, Michael Nolan htf...@gmail.com wrote: On Mon, Jan 12, 2015 at 7:46 PM, Bob Futrelle bob.futre...@gmail.com wrote: You should be able to find a cloud provider that could

[GENERAL] Re: Stuck trying to backup large database - best practice? How about a cloud service?

2015-01-12 Thread Bob Futrelle
You should be able to find a cloud provider that could give you many TB. Or so they like to claim. - Bob

[GENERAL] Installed postgres.app 9.3.1.0. pgadmin doesn't appear to see it

2013-12-18 Thread Bob Futrelle
I uninstalled 9.2 before installing 9.3.1.0. The app is called Postgres93, it is version 9.3.1.0 I downloaded the latest pgAdmin, it is pgAdmin3 version 1.18.1 I have a database MiniServer which is supposed to use postgres as its Maintenance database. But there is no such database. Perhaps it

Re: [GENERAL] I need more specific instructions for switching to digest mode for this list

2013-10-10 Thread Bob Futrelle
O'Donnell Sent: Wednesday, October 09, 2013 11:54 AM To: Bob Futrelle Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] I need more specific instructions for switching to digest mode for this list On 09/10/2013 16:47, Bob Futrelle wrote: Trying to switch to the digest didn't work

[GENERAL] I need more specific instructions for switching to digest mode for this list

2013-10-09 Thread Bob Futrelle
Trying to switch to the digest didn't work. How do I find more specific details about switching? On Wed, Oct 9, 2013 at 12:27 AM, Bob Futrelle bob.futre...@gmail.comwrote: set pgsql-general digest

[GENERAL]

2013-10-08 Thread Bob Futrelle
set pgsql-general digest

[GENERAL] How to restore some DBs to a new server?

2013-09-13 Thread Bob Futrelle
Running on my MacBook Pro, pgAdmin3 tells me I have four servers in Server Groups, all local, no network involved. I have dumped two of my DBs from a current server using pg_dump. Then in pgAdmin3 I created another server, let's call it New. I would like to look at these earlier DBs while not

[GENERAL] pgAdmin shows two servers with the identical data

2013-04-27 Thread Bob Futrelle
started with it late last year and have never looked back. PG is definitely one cool DB system. Thanks guys. My data is 120,000 biology papers, HTML, and a great deal of secondary data I generate from them. - Bob Futrelle

[GENERAL] JDBC - Need to declare variables for values in insert statement

2013-01-28 Thread Bob Futrelle
Do the declare statements and insert all have to be done in one statement execute()? That is, what is the scope of variables I declare? I see a variety of syntax examples, some for older versions? I'm using pg 9.2.2, so what are the rules/syntax for declaring and using variables? Use case: I

Re: [GENERAL] JDBC - Need to declare variables for values in insert statement

2013-01-28 Thread Bob Futrelle
value? * Results viewed in pgAdmin3 with query 'select * from public.hello'. * * Jar in classpath is postgresql-9.2-1002.jdbc4.jar * * @version 0.1 Mon Jan 28 EST 2013 * @author Bob Futrelle */ public class JDBCVariableTest { Connection db; Statement st; Boolean boo; public static void

Re: [GENERAL] database design best pratice help

2013-01-28 Thread Bob Futrelle
Yes. The general rules are: Many normalized tables. OK. Denormalizing simply to reduce the number of tables. Not OK. - Bob On Mon, Jan 28, 2013 at 1:47 PM, Kevin Grittner kgri...@ymail.com wrote: Jose Soares jose.soa...@sferacarta.com wrote: In my db I have about one hundred tables

Re: [GENERAL] JDBC - Need to declare variables for values in insert statement

2013-01-28 Thread Bob Futrelle
is the first parameter, 2 is the second parameter, and so on. Regards, Edson Richter Em 28/01/2013 16:50, Bob Futrelle escreveu: Here's a small, but complete code example - Bob package us.tsos.dbs.pg; import java.sql.*; /** * This is an effort to get a computed value from

Re: [GENERAL] JDBC - Need to declare variables for values in insert statement

2013-01-28 Thread Bob Futrelle
a very well explained section about JDBC: http://docs.oracle.com/javase/tutorial/jdbc/index.html and the chapter about PreparedStatements: http://docs.oracle.com/javase/tutorial/jdbc/basics/prepared.html Regards, Edson Richter Em 28/01/2013 17:09, Bob Futrelle escreveu: Thanks to Edson