Thanks
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On 24.2.2015 19:58, John McKown wrote:
> I normally do the command (in psql)
>
> \d+
>
> But if you want an actual SQL statement, the above invokes:
>
> SELECT n.nspname as "Schema",
> c.relname as "Name",
> CASE c.relkind WHEN 'r' THEN 'table' WHEN 'v' THEN 'view' WHEN 'm'
> THEN 'materiali
I normally do the command (in psql)
\d+
But if you want an actual SQL statement, the above invokes:
SELECT n.nspname as "Schema",
c.relname as "Name",
CASE c.relkind WHEN 'r' THEN 'table' WHEN 'v' THEN 'view' WHEN 'm'
THEN 'materialized view' WHEN 'i' THEN 'index' WHEN 'S' THEN
'sequence' WH
Hello, I'd like to see all the tables in my data base,
but can't figure out how to access th information scheme.
Thanks
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On 06/07/2011 04:17 AM, Heine Ferreira wrote:
Hi
Does Postgresql utilize hyperthreading and multiple cores on the
relevant processors on windows?
Sort-of. PostgreSQL runs many processes, one per query. Each process has
a single thread. This means that one query can use at most one CPU core,
: [GENERAL] newbie question
Hi
Does Postgresql utilize hyperthreading and multiple cores on the relevant
processors on windows?
Thanks
H.F.
On Mon, Jun 6, 2011 at 4:17 PM, Heine Ferreira wrote:
> Hi
>
> Does Postgresql utilize hyperthreading and multiple cores on the relevant
> processors on windows?
>
> Thanks
>
> H.F.
>
>
It certainly looks like it on my machine! As far as my Linux box can tell,
the "hyperthreaded" CPUs just appear
Hi
Does Postgresql utilize hyperthreading and multiple cores on the relevant
processors on windows?
Thanks
H.F.
How do people implement insert or upate ( otherwise known as upsert ) behaviour
in postgres i.e. insert a row if it's key does not exist in the database else
update the existing row?
I tried using an insert rule to delete any existing rows first then insert
however this leads to infinitely r
On 11/20/2010 02:43 PM, Thomas Kellerer wrote:
> Grant Mckenzie wrote on 20.11.2010 07:00:
>> How do people implement insert or upate ( otherwise known as upsert )
>> behaviour in postgres i.e. insert a row if it's key does not exist in
>> the database else update the existing row?
>>
>
> You can s
Grant Mckenzie wrote on 20.11.2010 07:00:
How do people implement insert or upate ( otherwise known as upsert )
behaviour in postgres i.e. insert a row if it's key does not exist in
the database else update the existing row?
You can simply send the UPDATE, if nothing was updated, it's safe to
Hi,
a question that I imagine is a faq but have not been able to find much help.
How do people implement insert or upate ( otherwise known as upsert ) behaviour
in postgres i.e. insert a row if it's key does not exist in the database else
update the existing row?
I tried using an insert rule t
On Mon, Nov 9, 2009 at 3:12 PM, Richard Sickler
wrote:
> Hi List,
>
> I'm trying to create a tablespace using the following command copied
> from pg_dumpall,
>
> CREATE TABLESPACE test OWNER postgres LOCATION 'd:/prodb';
>
> I receive the following message
>
> ERROR: directory "d:/proddb" is not
Hi List,
I'm trying to create a tablespace using the following command copied
from pg_dumpall,
CREATE TABLESPACE test OWNER postgres LOCATION 'd:/prodb';
I receive the following message
ERROR: directory "d:/proddb" is not empty
a \db yields
List of tablespaces
Name| Owner |
Thom Brown a écrit :
...
2009/10/29 Daniel Chiaramello :
Never mind, I found how finally:
UPDATE
product
SET
qty = qty+s_count
FROM (
SELECT
intermediate.product_id,
count(*) AS s_count
FROM
intermediate,
orders
WHERE
2009/10/29 Daniel Chiaramello :
> Never mind, I found how finally:
>
> UPDATE
> product
> SET
> qty = qty+s_count
> FROM (
> SELECT
> intermediate.product_id,
> count(*) AS s_count
> FROM
> intermediate,
> orders
> WHERE
> orde
Never mind, I found how finally:
UPDATE
product
SET
qty = qty+s_count
FROM (
SELECT
intermediate.product_id,
count(*) AS s_count
FROM
intermediate,
orders
WHERE
orders.intermediate_id=intermediate.id
GROUP BY
Hello.
I have a very basic question, relative to the following "problem".
I have the following tables:
product
id
qty
intermediate
id
product_id
orders
intermediate_id
I want to update the "qty" field of the "product" table by incrementing
it each time there is an order in th
2009/6/1 Andrew Smith :
> 2009/6/2 björn lundin
>>
>> > CREATE TABLE "DataImport"
>> > (
>> > "DataImportID" serial NOT NULL PRIMARY KEY,
>> > "Time" timestamp without time zone NOT NULL,
>> > "ID_ABC" integer NOT NULL,
>> > "ID_DEF" integer NOT NULL,
>> > "ID_HIJ" integer NOT NULL,
>> >
On Tue, Jun 2, 2009 at 2:27 PM, Merlin Moncure wrote:
> _IF_ arrays fit your requirements, they are an extremely compact and
> efficient way to store your data. The requirements are exact..you
> can't update or extract a single piece of data out of a block
> efficiently. While indexing techniqu
On Mon, Jun 1, 2009 at 8:41 AM, Sam Mason wrote:
> On Mon, Jun 01, 2009 at 06:53:30AM -0500, Chris Spotts wrote:
>> I just finished doing something very close to this - not quite once per
>> minute, but close. I started off with an array of integers and after about
>> a month of it, I'm having to
2009/6/2 björn lundin
>
> > CREATE TABLE "DataImport"
> > (
> > "DataImportID" serial NOT NULL PRIMARY KEY,
> > "Time" timestamp without time zone NOT NULL,
> > "ID_ABC" integer NOT NULL,
> > "ID_DEF" integer NOT NULL,
> > "ID_HIJ" integer NOT NULL,
> > etc
> > );
>
> Perhaps you want
2009/6/1 björn lundin :
>
>> CREATE TABLE "DataImport"
>> (
>> "DataImportID" serial NOT NULL PRIMARY KEY,
>> "Time" timestamp without time zone NOT NULL,
>> "ID_ABC" integer NOT NULL,
>> "ID_DEF" integer NOT NULL,
>> "ID_HIJ" integer NOT NULL,
>> etc
>> );
>
> Perhaps you want to not u
> CREATE TABLE "DataImport"
> (
> "DataImportID" serial NOT NULL PRIMARY KEY,
> "Time" timestamp without time zone NOT NULL,
> "ID_ABC" integer NOT NULL,
> "ID_DEF" integer NOT NULL,
> "ID_HIJ" integer NOT NULL,
> etc
> );
Perhaps you want to not use the "" around the table and column
one word, horizontal structure. you are trying to sort 1500 colums,
instead of creating 1500 rows per entry...
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Mon, Jun 01, 2009 at 06:53:30AM -0500, Chris Spotts wrote:
> I just finished doing something very close to this - not quite once per
> minute, but close. I started off with an array of integers and after about
> a month of it, I'm having to redesign my way out of it.
I've had to go the other w
gsql-general-ow...@postgresql.org] On Behalf Of Sam Mason
Sent: Monday, June 01, 2009 5:00 AM
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] newbie table design question
On Sun, May 31, 2009 at 11:54:09PM +0800, Andrew Smith wrote:
> I'm a beginner when it comes to Postgresql, and have
On Sun, May 31, 2009 at 11:54:09PM +0800, Andrew Smith wrote:
> I'm a beginner when it comes to Postgresql, and have a table design question
> about a project I'm currently working on. I have 1500 data items that need
> to be copied every minute from an external system into my database. The
> ite
On Mon, Jun 1, 2009 at 1:25 AM, Tom Lane wrote:
> Andrew Smith writes:
> > I'm a beginner when it comes to Postgresql, and have a table design
> question
> > about a project I'm currently working on. I have 1500 data items that
> need
> > to be copied every minute from an external system into m
Andrew Smith writes:
> I'm a beginner when it comes to Postgresql, and have a table design question
> about a project I'm currently working on. I have 1500 data items that need
> to be copied every minute from an external system into my database. The
> items have a timestamp, an identifier and a
Hi all,
I'm a beginner when it comes to Postgresql, and have a table design question
about a project I'm currently working on. I have 1500 data items that need
to be copied every minute from an external system into my database. The
items have a timestamp, an identifier and a value. For example:
On Sunday, March 08, 2009, Tom Lane wrote:
> Carl Sopchak writes:
> > Here's what's around the error message in the log:
> >
> > SPI Proc: 3154128080 total in 398 blocks; 13664 free (178 chunks);
> > 3154114416 used
>
> Hmm, so apparently some internal leak within the plpgsql engine. I'd be
>
Carl Sopchak writes:
> Here's what's around the error message in the log:
> SPI Proc: 3154128080 total in 398 blocks; 13664 free (178 chunks);
> 3154114416 used
Hmm, so apparently some internal leak within the plpgsql engine. I'd be
willing to look into this if you can provide a self-conta
On Sunday, March 08, 2009, Tom Lane wrote:
> Carl Sopchak writes:
> > On Sunday, March 08, 2009, Gregory Stark wrote:
> >> What do you mean you're running out of memory?
> >
> > "ERROR: Out of Memory" is what I meant when I said I was running out of
> > memory! :-) This is returned by psql, but
On Sunday, March 08, 2009, Alvaro Herrera wrote:
> Carl Sopchak wrote:
> > Well, the upgrade to 8.3 seemed to rid me of the command limit, but now
> > I'm running out of memory. I have 2Gb physical and 8Gb swap (after
> > adding 4Gb).
>
> Do you have AFTER triggers on the involved tables? They ar
Carl Sopchak wrote on 08.03.2009 17:37:
or a way to run a function outside an implicit transaction
No sensible DBMS will let you do _anything_ outside a transaction
Thomas
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.
Carl Sopchak writes:
> On Sunday, March 08, 2009, Gregory Stark wrote:
>> What do you mean you're running out of memory?
> "ERROR: Out of Memory" is what I meant when I said I was running out of
> memory! :-) This is returned by psql, but it is the postmaster process that
> is hitting the wal
On Sunday, March 08, 2009, Gregory Stark wrote:
> Carl Sopchak writes:
> > Well, the upgrade to 8.3 seemed to rid me of the command limit, but now
> > I'm running out of memory. I have 2Gb physical and 8Gb swap (after
> > adding 4Gb).
>
> What do you mean you're running out of memory? For most pa
Carl Sopchak wrote:
> Well, the upgrade to 8.3 seemed to rid me of the command limit, but now I'm
> running out of memory. I have 2Gb physical and 8Gb swap (after adding 4Gb).
Do you have AFTER triggers on the involved tables? They are recorded on
memory and we have no mechanism to spill to dis
Carl Sopchak writes:
> Well, the upgrade to 8.3 seemed to rid me of the command limit, but now I'm
> running out of memory. I have 2Gb physical and 8Gb swap (after adding 4Gb).
What do you mean you're running out of memory? For most part of Postgres
that's only a problem if you've configured i
Well, the upgrade to 8.3 seemed to rid me of the command limit, but now I'm
running out of memory. I have 2Gb physical and 8Gb swap (after adding 4Gb).
Is there a way for me to run this outside of one huge transaction? This
really shouldn't be using more than a few hundred megs of RAM (assumin
Carl Sopchak writes:
> I have written a PL/pgSQL function that performs these calculations by
> reading
> the needed data, calculating, and saving the results. When run over a
> smaller set of data, it works fine. But when I tried to run it over this
> larger set of data, I got the error mes
Hi,
I'm new to pgsql (but not databases in general) and I've run into a roadblock
that I'm having difficulty figuring out how to get around. Any help would be
greatly appreciated!
I'm using the database to store the results of calculations over data in some
tables. There are a lot of data re
On Tue, 2008-08-12 at 17:25 +0200, Daneel wrote:
>
> When I run
> service postgresql initdb
> I get
> "se: [FAILED]".
> However, /var/lib/pqsql/data is created and user postgres owns it.
>
> But then I run
> service postgresql start
> and the very same error occurs..
Anything in /var/lib/pgs
On Thu, Aug 14, 2008 at 4:18 AM, Daneel <[EMAIL PROTECTED]> wrote:
> Martin Marques wrote:
>>
>> Daneel escribió:
>>>
>>> Daneel wrote:
While going through
http://wiki.postgresql.org/wiki/Detailed_installation_guides
and typing
service postgresql start
as root I got
>>
Scott Marlowe wrote:
On Tue, Aug 12, 2008 at 9:25 AM, Daneel <[EMAIL PROTECTED]> wrote:
While going through
http://wiki.postgresql.org/wiki/Detailed_installation_guides
and typing
service postgresql start
as root I got
"/var/lib/pgsql/data is missing. Use "service postgresql initdb" to
initializ
Martin Marques wrote:
Daneel escribió:
Daneel wrote:
While going through
http://wiki.postgresql.org/wiki/Detailed_installation_guides
and typing
service postgresql start
as root I got
"/var/lib/pgsql/data is missing. Use "service postgresql initdb" to
initialize the cluster first."
When I r
Scott Marlowe wrote:
PLEASE DON'T WRITE TO THIS LIST WITH A FAKE EMAIL ADDRESS.
It's been discussed before, but it's rude and counterproductive. Just
set up a filter / account that drops everything coming in, but don't
stick the rest of us with your broken email behaviour
I'm sorry, just foll
Daneel escribió:
Daneel wrote:
While going through
http://wiki.postgresql.org/wiki/Detailed_installation_guides
and typing
service postgresql start
as root I got
"/var/lib/pgsql/data is missing. Use "service postgresql initdb" to
initialize the cluster first."
When I run
service postgresql i
PLEASE DON'T WRITE TO THIS LIST WITH A FAKE EMAIL ADDRESS.
It's been discussed before, but it's rude and counterproductive. Just
set up a filter / account that drops everything coming in, but don't
stick the rest of us with your broken email behaviour
On Tue, Aug 12, 2008 at 9:25 AM, Daneel <[EM
On Tue, Aug 12, 2008 at 9:25 AM, Daneel <[EMAIL PROTECTED]> wrote:
> While going through
> http://wiki.postgresql.org/wiki/Detailed_installation_guides
> and typing
> service postgresql start
> as root I got
> "/var/lib/pgsql/data is missing. Use "service postgresql initdb" to
> initialize the clus
Daneel escribió:
While going through
http://wiki.postgresql.org/wiki/Detailed_installation_guides
and typing
service postgresql start
as root I got
"/var/lib/pgsql/data is missing. Use "service postgresql initdb" to
initialize the cluster first."
When I run
service postgresql initdb
I get
"se
Daneel <[EMAIL PROTECTED]> writes:
> When I run
> service postgresql initdb
> I get
> "se: [FAILED]".
> However, /var/lib/pqsql/data is created and user postgres owns it.
Is there anything in /var/lib/pgsql/pgstartup.log ? How about the
main /var/log/messages file?
re
While going through
http://wiki.postgresql.org/wiki/Detailed_installation_guides
and typing
service postgresql start
as root I got
"/var/lib/pgsql/data is missing. Use "service postgresql initdb" to
initialize the cluster first."
When I run
service postgresql initdb
I get
"se: [FAILED]".
H
Daneel wrote:
While going through
http://wiki.postgresql.org/wiki/Detailed_installation_guides
and typing
service postgresql start
as root I got
"/var/lib/pgsql/data is missing. Use "service postgresql initdb" to
initialize the cluster first."
When I run
service postgresql initdb
I get
"se:
On 10/23/07, ahnf <[EMAIL PROTECTED]> wrote:
> Whenever a row is updated in a table with a timestamp column. How do I write
> a trigger to set that timestamp column to now() or the current timestamp?
You should be able to take a virtual chainsaw to the example on this
page and do it:
http://www.
On 10/23/07, ahnf <[EMAIL PROTECTED]> wrote:
> Whenever a row is updated in a table with a timestamp column. How do I write
> a trigger to set that timestamp column to now() or the current timestamp?
Straight from the horse's mouth:
http://www.postgresql.org/docs/8.2/static/plpgsql-trigger.html#P
Whenever a row is updated in a table with a timestamp column. How do I write a
trigger to set that timestamp column to now() or the current timestamp?
thanks
---(end of broadcast)---
TIP 6: explain analyze is your friend
>-Original Message-
>From: Russell Aspinwall [mailto:[EMAIL PROTECTED]
>Sent: woensdag 17 oktober 2007 11:37
>To: Joris Dobbelsteen
>Subject: Re: [GENERAL] newbie question
>
>Joris Dobbelsteen wrote:
>>> -Original Message-
>>> From: [EMAIL
>-Original Message-
>From: [EMAIL PROTECTED]
>[mailto:[EMAIL PROTECTED] On Behalf Of
>Russell Aspinwall
>Sent: woensdag 17 oktober 2007 9:34
>To: pgsql-general@postgresql.org
>Subject: [GENERAL] newbie question
>
>Hi,
>
>[snip] For example, if you had a
Hi,
In the mid 1990's I used the Progress Database which had a great feature
where the it was possible to set the software version in the
configuration file. For example, if you had a built a database and
application using version 3 and then upgraded the version 7, it was
possible to set the
SELECT min(x) FROM
(
SELECT min(datecol1) AS x FROM table1
UNION ALL
SELECT min(datecol2) AS x FROM table2
UNION ALL
SELECT min(datecol3) AS x FROM table3
) ss;
Exercise for newbie: which of the AS clauses are redundant?
Um, all of them?
Yah, but only if you do this:
SELECT min(*) FROM
(
Tom Lane wrote:
"Dann Corbit" <[EMAIL PROTECTED]> writes:
[EMAIL PROTECTED] On Behalf Of Lorenzo Thurman
I have three tables using date fields. I want to retrieve the oldest
date contained in the tables. Can someone show me an example of a query
that would do that?
Just do a union and return
Lorenzo Thurman wrote:
I have three tables using date fields. I want to retrieve the oldest
date contained in the tables. Can someone show me an example of a query
that would do that?
TIA
I think I have it, but if anyone has any comments, I'd appreciate it:
select min(old) as oldest from (se
Brent Wood wrote:
Lorenzo Thurman wrote:
I have three tables using date fields. I want to retrieve the oldest
date contained in the tables. Can someone show me an example of a
query that would do that?
You could write a custom function doing the same sort of thing, or
(perhaps more portable) u
Lorenzo Thurman wrote:
I have three tables using date fields. I want to retrieve the oldest
date contained in the tables. Can someone show me an example of a
query that would do that?
You could write a custom function doing the same sort of thing, or
(perhaps more portable) use generic sqls & v
On 4/9/07, Tom Lane <[EMAIL PROTECTED]> wrote:
"Dann Corbit" <[EMAIL PROTECTED]> writes:
>> [EMAIL PROTECTED] On Behalf Of Lorenzo Thurman
>> I have three tables using date fields. I want to retrieve the oldest
>> date contained in the tables. Can someone show me an example of a query
>> that wou
"Dann Corbit" <[EMAIL PROTECTED]> writes:
>> [EMAIL PROTECTED] On Behalf Of Lorenzo Thurman
>> I have three tables using date fields. I want to retrieve the oldest
>> date contained in the tables. Can someone show me an example of a query
>> that would do that?
> Just do a union and return the min
Just do a union and return the min
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:pgsql-general-
> [EMAIL PROTECTED] On Behalf Of Lorenzo Thurman
> Sent: Monday, April 09, 2007 7:32 AM
> To: pgsql-general@postgresql.org
> Subject: [GENERAL] NEWBIE: How do I g
I have three tables using date fields. I want to retrieve the oldest
date contained in the tables. Can someone show me an example of a query
that would do that?
TIA
---(end of broadcast)---
TIP 6: explain analyze is your friend
Hello,
I'm new to postgreSQL (not databases) and trying to find my way arouund.
Have a couple of questions:
(a) In which dir is the pg_global stored?
Is it "C:\Program Files\PostgreSQL\8.2\data\global"?
(b) Why is the pg_tablespace.spclocation column=null for pg_default &
pg_global?
(c) When
On Wed, Jan 17, 2007 at 07:02:13PM +0530, Alexi Gen wrote:
> Hello,
>
> I'm new to postgreSQL (not databases) and trying to find my way arouund.
> Have a couple of questions:
>
> (a) In which dir is the pg_global stored?
> Is it "C:\Program Files\PostgreSQL\8.2\data\global"?
Yes.
> (b) Why is t
Hello,
I'm new to postgreSQL (not databases) and trying to find my way arouund.
Have a couple of questions:
(a) In which dir is the pg_global stored?
Is it "C:\Program Files\PostgreSQL\8.2\data\global"?
(b) Why is the pg_tablespace.spclocation column=null for pg_default &
pg_global?
(c) When
On Mon, Jan 08, 2007 at 14:55:29 -0600,
Jeanna Geier <[EMAIL PROTECTED]> wrote:
>
> Not quite sure what the: CONSTRAINT "Relationship182" is exactly... can
> anyone help me with this one? Haven't seen this one yet...
It is the name of that particular constraint. You would use that if you
wer
Jeanna Geier wrote:
Hello List!
OK, so I'm new to SQL and Postgres and am working on taking over this DB
work, and ran across a command that I'm not sure of and am wondering if you
can help me with... Probably a basic SQL question, but thought more than one
person on here would be able to poin
Hello List!
OK, so I'm new to SQL and Postgres and am working on taking over this DB
work, and ran across a command that I'm not sure of and am wondering if you
can help me with... Probably a basic SQL question, but thought more than one
person on here would be able to point me in the right dire
Ron Johnson wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 10/18/06 20:41, andrew plata wrote:
I am trying to following the instructions at URL below to try to create a
database called web_database required for phpPgAdmin. When I try to do this
I get the following error:
template1=# c
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 10/18/06 20:41, andrew plata wrote:
> I am trying to following the instructions at URL below to try to create a
> database called web_database required for phpPgAdmin. When I try to do this
> I get the following error:
>
> template1=# create databa
andrew plata wrote:
I am trying to following the instructions at URL below to try to create
a database called web_database required for phpPgAdmin. When I try to do
this I get the following error:
template1=# create database web_database owner web_user;
ERROR: could not write to file "base/16
I am trying to following the instructions at URL below to try to create a database called web_database required for phpPgAdmin. When I try to do this I get the following error:template1=# create database web_database owner web_user;
ERROR: could not write to file "base/16390/2682": No space left o
On Tue, 2006-10-10 at 04:16, Ron Johnson wrote:
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> On 10/09/06 22:43, Jonathan Greenberg wrote:
> > So I've been looking at the documentation for COPY, and I'm curious about a
> > number of features which do not appear to be included, and whether
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 10/09/06 22:43, Jonathan Greenberg wrote:
> So I've been looking at the documentation for COPY, and I'm curious about a
> number of features which do not appear to be included, and whether these
> functions are found someplace else:
>
> 1) How do I
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 10/10/06 01:44, Merlin Moncure wrote:
> On 10/10/06, Jonathan Greenberg <[EMAIL PROTECTED]> wrote:
>> So I've been looking at the documentation for COPY, and I'm curious
>> about a
>> number of features which do not appear to be included, and whethe
On 10/10/06, Jonathan Greenberg <[EMAIL PROTECTED]> wrote:
So I've been looking at the documentation for COPY, and I'm curious about a
number of features which do not appear to be included, and whether these
functions are found someplace else:
1) How do I skip an arbitrary # of "header" lines
So I've been looking at the documentation for COPY, and I'm curious about a
number of features which do not appear to be included, and whether these
functions are found someplace else:
1) How do I skip an arbitrary # of "header" lines (e.g. > 1 header line) to
begin reading in data?
2) Is it possi
Michael Fuhr wrote:
On Thu, Aug 17, 2006 at 03:27:26PM -0400, Walter Vaughan wrote:
ERROR: missing data for column "processed_timestamp"
The table you posted has 42 columns; at least one line in the file
doesn't have that many fields.
Yes, we didn't have the right number of columns...
We
On Thu, Aug 17, 2006 at 03:27:26PM -0400, Walter Vaughan wrote:
> Admin_=# COPY DATA_IMPORT_CUSTOMER FROM '/tmp/sold.pg' delimiter '|' null
> '';
> ERROR: missing data for column "processed_timestamp"
> CONTEXT: COPY data_import_customer, line 1: "(xxx) xxx-||Mary|Smith|76
> Crest Street||J
On Thursday 17 August 2006 03:27 pm, Walter Vaughan
<[EMAIL PROTECTED]> thus communicated:
> The problem is I need to load a field that is allowed to be null with
> nothing and it work
The above statement is not the problem you are having. We dumped and loaded a
4 gig Progress database with
For the past few months we have been experimenting with using MySQL with Apache
OFBiz. However, we are not sure that we can live with the performance.
We have a large dataset that we wanted to import into PostgreSQL, but it seems
to fail no matter what we do. We tried ever nuance we could to ge
Thiago Germano Beier wrote:
Hi all,
I'm using postgresql version 8.1 on FREEBSD 6.x
some info -
bash-2.05b# pkg_info | grep post
postgresql-client-8.1.4 PostgreSQL database (client)
postgresql-docs-8.1.4 The PostgreSQL documentation set
postgresql-relay-1.3.1 Multiplex multiple Postgre
Hi all, I'm using postgresql version 8.1 on FREEBSD 6.x some info - bash-2.05b# pkg_info | grep postpostgresql-client-8.1.4 PostgreSQL database (client)postgresql-docs-8.1.4 The PostgreSQL documentation setpostgresql-relay-1.3.1 Multiplex multiple PostgreSQL databases to one relaypost
Sue,you can walk an easier road to get your Excel Table filled with PostgreSQL data:there is an ODBC.Driver for PostgreSQL, you can google it or find it within the standard PostgreSQL for Windows Installer.
After installing the ODBC driver, PostgreSQL is a normal data soure to Excel; you can put yo
> I am relatively new to PostgreSQL, having only been exposed to it with
> a recent DSpace implementation (in the last 8 months or so). I have created
> a new database in PostgreSQL and have written a SQL query against the
> database. The database resides on a Sunfire V440 Solaris 9 machine.
Hi,
I am relatively new to PostgreSQL, having only been exposed to it with a recent DSpace implementation (in the last 8 months or so). I have created a new database in PostgreSQL and have written a SQL query against the database. The database resides on a Sunfire V440 Solaris 9 machin
On Sat, Dec 24, 2005 at 08:41:49 -0400,
robert mena <[EMAIL PROTECTED]> wrote:
>
> If I'd need to define a user with SELECT privileges to all tables in
> my test database, how could I do that?
You can't. You can write a script that will give them access to all of the
tables that currently exist
Hi,
thanks for the reply.
I've already read the docs. I am using 8.0.5 btw.
One of the things I am confused is how can I give the privileges to
the database without having to know the specific tables.
The grant command when applied to a database simply mentions CREATE so
the user can create ta
Am Freitag, 23. Dezember 2005 22:06 schrieb robert mena:
> GRANT CREATE,REFERENCES ON DATABASE test TO testadm;
>
> \z
> Access privileges for database "test"
> Schema | Name | Type | Access privileges
> +--+--+---
>
> How can I specify that the user testadm can per
"robert mena" <[EMAIL PROTECTED]> wrote
>
> How can I specify that the user testadm can perform those actions to this
> database?
Use GRANT command (the opposite is REVOKE). I suppose you are using 8.1:
http://www.postgresql.org/docs/8.1/static/sql-grant.html
Regards,
Qingqing
-
Hi,
I am new to postgres but coming from a MySQL enviroment.
I am confused with the necessary steps to create users and restrict
them to access/delete/insert/update data and create/delete/alter tables
in a specific database.
I've created a database test and a user testadm
createdb test
create
On Tue, Dec 20, 2005 at 10:21:54PM +0100, Alexander Scholz wrote:
> Hi,
>
> is there a newbie's FAQ / book / link for "howto optimize databases with
> PostgreSQL"?
>
> Background: Customer has the Windows* (sorry ) Postgres 8.1.0
> standard installation "out of the box". A table has 2.5 mio reco
1 - 100 of 276 matches
Mail list logo
