[SQL][On-Rev] Bulk import into PostgreSQL on On-Rev
andre at andregarzia.com
Wed May 19 09:20:02 EDT 2010
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
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.
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
> 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://www.andregarzia.com All We Do Is Code.
More information about the Use-livecode