On Sunday, August 28, 2011 5:48:50 pm you wrote:
> > > error is.
> >
> > Is the above the only command being run? Where is this coming from?:
> >
> > LINE 1: ...(ANALYZE off, VERBOSE off, COSTS on, BUFFERS off )...
>
> Explain mode, in pgadminIII
>
> > > Using pgsql 9.1 rc1 on Ubuntu 11.04 (Gn
On Mon, Aug 29, 2011 at 11:21 AM, planas wrote:
> **
>
> CREATE TABLE "*ContactUpdates"*
> (
> "VendorID" integer NOT NULL,
> "LastName" character varying(45),
> "FirstName" character varying(45),
> CONSTRAINT "ContactUpdates_pkey" PRIMARY KEY ("VendorID" )
>
ERROR: relation "countupdates
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
On Saturday, August 27, 2011 10:03:53 pm planas wrote:
> 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 q
What if you run this query using psql?
--
pasman
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
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
