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

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

[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

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 wrote: > > > On Mon, Jan 12, 2015 at 7:46 PM, Bob Futrelle > wrote: > >> You should be able to find a cloud provider that could give

[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 colle

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

2013-01-28 Thread Bob Futrelle
Java 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; pub

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 wrote: > Jose Soares wrote: > > > In my db I have about one hundred tables like this: > > > > code > > description >

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

2013-01-28 Thread Bob Futrelle
ello values > ('bKey', ?)"); > st.setInteger(1, f1()); > > > where 1 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 sm

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

2013-01-28 Thread Bob Futrelle
t The Java Tutorial, that > has 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 Richt

[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] 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]

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

[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 wrote: > set pgsql-general digest >

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

2013-10-10 Thread Bob Futrelle
mond 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

[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