Re: Uploading and loading

From: "Jeff Eckermann" <jeff_eckermann(at)yahoo(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: Uploading and loading
Date: 2005-08-08 23:48:29
Message-ID: dd8r0g$1m6$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

"Sean" <scene(at)themountainscene(dot)com> wrote in message
news:42F69C21(dot)3030900(at)themountainscene(dot)com(dot)(dot)(dot)
> So far I've been relegated to phpPgAdmin to upload my data, but it has
> size limits, which I am exceeding. So I was told to ftp the backup
> files, and use PuTTY, which I've been trying to do. I'm getting
> connected, but don't know what to do next. None of the postgreSQL

I assume that you have a shell account on the server, and that you have a
command prompt? Check out the manual, Reference -> PostgreSQL Client
Applications. The primary application that you are interested in will be
"psql", which can be used interactively, or invoked from the OS command
line. Perhaps interactive is alround most useful, because the other client
applications have equivalents in SQL. But the ability to invoke these
applications from the command line makes them capable of being scripted,
which will enable you to automate routine functions, especially those to do
with data loading.

> commands are available. Is there something I'm missing? Any insight
> would be most appreciated.
>
> Sean
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster
>

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Lane Van Ingen 2005-08-09 00:38:51 Re: Date Arithmetic in PL/pgSql
Previous Message Tom Lane 2005-08-08 21:09:29 Re: Date Arithmetic in PL/pgSql