[SQL][On-Rev] Bulk import into PostgreSQL on On-Rev

[Andre Garzia]

Hi There Kay,

What is the format of the data? Is it a csv file or something? Because if it
is a text file, then you can upload the text file to your on-rev account and
then use a SQL command such as COPY to parse and load the file. You don't
need a option in phpPgAdmin to do it, you can just write the SQL command
there.

Check out http://www.postgresql.org/docs/8.1/static/sql-copy.html

With this you'll be able to load a csv (or similar) file into postgresql

It is not as straight forward as LOAD DATA INFILE but it is close.

Cheers
andre



On Wed, May 19, 2010 at 5:01 AM, Kay C Lan <lan.kc.macmail at gmail.com> wrote:

> I'm guessing Andre is the guru to answer this one.
>
> How does one populate a postgreSQL db on On-Rev in bulk?
>
> MySQL's phpMyAdmin gives you both an Import option and the ability to enter
> raw SQL commands, ie LOAD DATA LOCAL INFILE, but the postgreSQL's
> phpPgAdmin
> has neither option.
>
> I'm not going to manually type in thousands of records.
>
> Thanks in advance
>
> And Ruslan, if you're reading, if On-Rev offered Valentina Free Server, I'd
> be trying to figure out how to do this with Valentina rather than
> postgreSQL, especially as I'd assume it would be as easy as using Valentina
> Studio's Connect to... Server option.
> _______________________________________________
> use-revolution mailing list
> use-revolution at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-revolution
>



-- 
http://www.andregarzia.com All We Do Is Code.