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