On Sun, 2011-10-02 at 01:25 +0200, Reuven M. Lerner wrote:
> Hi, everyone. I'm working on a project on PostgreSQL 9.0 (soon to be
> upgraded to 9.1, given that we haven't yet launched). The project
> will involve numerous text fields containing English, Spanish, and
> Portuguese. Some of those
Gregor
On Thu, 2011-09-29 at 14:15 +0200, Gregor Vollmer wrote:
> Dear List,
>
> we are currently updating our application to use multiple database
> backends, the main backend on our site will be Postgres, though.
>
> Some of our columns exceed the limit of the 'integer' type, now we are
>
On Wed, 2011-09-28 at 12:33 +0530, Siva Palanisamy wrote:
> Hi All,
>
>
>
> I am trying to retrieve the contact names based on the keyed search
> string. It performs good for the English alphabets and behaves
> strangely for special chars such as _,/,\,%
>
>
The % character is used by SQL
, county etc.
>
>
> Thanks
>
> planas wrote:
>
> > On Tue, 2011-09-27 at 12:18 +0530, Adarsh Sharma wrote:
> >
> > > Dear all,
> > >
> > > I googled a lot and find data of all countries , cities ,
> > > location etc
On Tue, 2011-09-27 at 12:18 +0530, Adarsh Sharma wrote:
> Dear all,
>
> I googled a lot and find data of all countries , cities ,
> location etc from Geo Spatial websites but I am able to find the data
> that shows all states & their respective capitals in world.
> Please let me know if an
Rich
On Mon, 2011-09-26 at 11:38 -0700, Rich Shepard wrote:
> Rather than writing an application right now to enter data into a table I
> thought of trying LibreOffice as a front end. But, it doesn't seem to work
> as OO.o did. This leads to two questions:
>
>1) Can someone show me how to
On Sun, 2011-08-28 at 03:53 -0200, pasman pasmański wrote:
> What if you run this query using psql?
>
> --
>
> pasman
>
When I run the following:
DROP Table "ContactUpdates"
CREATE TABLE "ContactUpdates"
(
"VendorID" integer NOT NULL,
"LastName" character varying(45),
"F
On Sun, 2011-08-28 at 03:53 -0200, pasman pasmański wrote:
> What if you run this query using psql?
>
> --
>
> pasman
>
It did import the data and it gave no error messages
--
Jay Lozier
jsloz...@gmail.com
Hi,
I am attempting to import a csv file into a predefined, empty table
using the following commands:
COPY ContactUpdates
FROM '/media/Fred/Work/SQL_Server/AP/ContactUpdates.csv'
WITH DELIMITERS ',' CSV
When testing the query I get the following error message
ERROR: syntax error at or near "CO
