Skip site navigation (1) Skip section navigation (2)

Re: Execute A String of Query

From: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
To: lonh SENG <slonh(at)camgsm(dot)com(dot)kh>
Cc: <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Execute A String of Query
Date: 2002-01-23 05:21:00
Message-ID: 20020122211939.Q12547-100000@megazone23.bigpanda.com (view raw or flat)
Thread:
Lists: pgsql-admin
On Wed, 23 Jan 2002, lonh SENG wrote:

> Hi all,
>
>     I am really new to Postgres. But I am familiar with SQL Server.
>
>     I want import data from delimiter file.
>     How can I do this?
>     My delimiter file is as following:
>
> uid|username
> ----+---------
> 2974|012801849
> 3883|012950864
> 6015|012990918
> 4512|012854963
> (4 rows)
>
>     Anyone has an idea?

Well, if you trim off the header/footer info, you can probably
read the data using COPY.


In response to

pgsql-admin by date

Next:From: Nick FankhauserDate: 2002-01-23 10:46:33
Subject: Re: Execute A String of Query
Previous:From: Daniel AndersenDate: 2002-01-23 04:25:18
Subject: Re: Execute A String of Query

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group