e data for every article.'
- Bob Futrelle
You should be able to find a cloud provider that could give you many TB.
Or so they like to claim.
- Bob
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
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
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
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
>
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
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
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
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
set pgsql-general digest
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
>
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
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
14 matches
Mail list logo