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

[Kay C Lan]

Andre,

thanks for the pointers. Got everything working plus after playing with
phpPgAdmin found a few more features.

Much appreciated.

On Wed, May 19, 2010 at 9:20 PM, Andre Garzia <andre at andregarzia.com> wrote:

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