> On Thu, 24 Aug 2000, Roderick A. Anderson wrote:
>
> > On Thu, 24 Aug 2000, John McKown wrote:
> >
> > > I think that you can do this using the COPY verb in psql.
> > >
> > > COPY table FROM file USING DELIMITERS ',';
> >
> > Be aware you will probably have to start psql as the postgres
(sup
On Thu, 24 Aug 2000, Roderick A. Anderson wrote:
> On Thu, 24 Aug 2000, John McKown wrote:
>
> > I think that you can do this using the COPY verb in psql.
> >
> > COPY table FROM file USING DELIMITERS ',';
>
> Be aware you will probably have to start psql as the postgres (superuser)
> to use t
On Thu, 24 Aug 2000, John McKown wrote:
> I think that you can do this using the COPY verb in psql.
>
> COPY table FROM file USING DELIMITERS ',';
Be aware you will probably have to start psql as the postgres (superuser)
to use the COPY command.
But ... the \copy version is usable by normal us
John McKown wrote:
>
> I think that you can do this using the COPY verb in psql.
>
> COPY table FROM file USING DELIMITERS ',';
>
> Just be sure that the order of the data in the file is the same as the
> order of the variables in the table.
>
> John
>
> On Wed, 23 Aug 2000, Jake wrote:
> > D
I think that you can do this using the COPY verb in psql.
COPY table FROM file USING DELIMITERS ',';
Just be sure that the order of the data in the file is the same as the
order of the variables in the table.
John
On Wed, 23 Aug 2000, Jake wrote:
> Does any one know if this is possible, and
I currently have postgres on a Linux 6.2 machine & I can access all of its
information from any windows machine using the proper odbc driver.
Now I want to go in the other direction - Is there a way for my postgres
server on the linux box to pull down information from a windows client that
is usi
I'm using the IMPORT Table feature of pgaccess to import a .txt file.
I've done this before and usually have no problems..
The table I'm importing into however has a field which I intended to be an
auto numbering field.. INT DEFAULT nextval('team_id') and I have a
sequence of team_id
however wh