On Sun, Mar 6, 2011 at 1:46 AM, John R Pierce wrote:
> On 03/05/11 2:05 PM, Allan Kamau wrote:
>>
>> Is it possible in theory to efficiently perform count the primary or
>> unique indices underlying data structures, regardless whether there is
>> a WHERE clause detailing filtration base on values
Rimu hosting allows you to install whatever you want, including
Postgres... which I have done before now. If your project is in support
of Open Source software in any way, ask what discount they can offer,
they have been pretty generous in that arena.
http://rimuhosting.com/
Like many hosting com
Hello,
Thanks for all your answers.
I have read that the cascaded replication will be probably available in
future releases (cf.
http://wiki.postgresql.org/wiki/Streaming_Replication#Synchronization_capabilityat
the bottom of the page)
As I understand the streaming replication, we are able to h
On Sun, Mar 06, 2011 at 11:03:23AM +0300, Allan Kamau wrote:
> I would assume the primary key or unique indexes are the cornerstone
> of each insertion and deletion.
> Or am I missing a crucial point.
The real issue is that you can have four programs all doing count(*)
and all getting different
On 6 Mar 2011, at 9:03, Allan Kamau wrote:
> If this is true it seems that the primary key and perhaps other unique
> indexes do indeed contain exact details of the uniqueness of the
> persisted tuples of a given relation at any given time.
That is true within a single transaction, but indexes co
Hello,
what is please the command to copy tables from 1 database
from another and is it possible at all without using pg_dump?
I'm trying to migrate 4700 users from phpBB 3 to Drupal 7
and have few custom tables in the "phpbb" database
which need to be copied over.
Using CentOS 5.5/64 bit + Post
On Mar 6, 2011, at 7:13 PM, Alexander Farber wrote:
> what is please the command to copy tables from 1 database
> from another and is it possible at all without using pg_dump?
You can create Structure of table in New database and then you can use COPY
Command to copy data as given below:
psql
Hi,
Just another question about this subject.
It is possible to compare if these 3 PlpgSQL arrays have the same
number of elements? How to get the number of elements of an PLpgSQL
array?
NOTICE: file types: {image,image,image,image,image}
NOTICE: file details: {type,width,height,html_width_hei
Hello
look on array_lower and array_upper functions
http://www.postgresql.org/docs/8.2/static/functions-array.html
for one dimensional arrays - select array_upper(var,1) - array_lower(var,1)
Regards
Pavel Stehule
2011/3/6 Andre Lopes :
> Hi,
>
> Just another question about this subject.
>
> I
Hi Pavel,
Thanks for the reply. It was exactly that that I'm looking for.
Best Regards,
On Sun, Mar 6, 2011 at 3:05 PM, Pavel Stehule wrote:
> Hello
>
> look on array_lower and array_upper functions
>
> http://www.postgresql.org/docs/8.2/static/functions-array.html
>
> for one dimensional arr
On Sat, 5 Mar 2011 15:33:50 -0500
wrote:
> Hello,
I tried to enter the commands on the SQL Shell(psql) from
> which line 1 reads Server [localhost], line 2 –Database[postgres]:
> and I entered postgres, line 3 – Port[], which number I entered),
> line 4 - Username[postgres], where I entered
On 3/5/2011 4:08 PM, matty jones wrote:
I already have a domain name but I am looking for a hosting company that I can use PG with. The few I have
contacted have said that they support MySQL only and won't give me access to install what I need or they
want way to much. I don't need a dedicated
I am working with a system which periodically has to perform this operation:
update all of the rows in table A which match rows in table B, using a
subset of the columns for comparison (and one of the columns in tableA
is NULL).
This is what I've tried:
update tableA
SET column1 = some_value
FRO
I would like to create a table from a CSV file (the first line is
headers which I want to use as column names) saved from Excel. I have
a new database which I have been able to create tables from a
tutorial. But I haven’t been able to produce this new table. The
following are my attempts:
CREAT
On Mar 7, 2011, at 12:13 AM, ray wrote:
>
> CREATE TABLE Equpment_List_Sheet2 FROM 'Equipment List, reference
> r1_Sheet2.csv' WITH DELIMITER ',' NULL '' CSV HEADER;
> ERROR: syntax error at or near "FROM"
> LINE 1: CREATE TABLE Equpment_List_Sheet2 FROM 'Equipment List,
> refe...
>
> ^
>
On Sun, 6 Mar 2011, ray wrote:
I would like to create a table from a CSV file (the first line is
headers which I want to use as column names) saved from Excel. I have
a new database which I have been able to create tables from a
tutorial. But I haven?t been able to produce this new table. The
At 17:24 06/03/2011, you wrote:
On 3/5/2011 4:08 PM, matty jones wrote:
I already have a domain name but I am looking for a hosting company
that I can use PG with. The few I have contacted have said that
they support MySQL only and won't give me access to install what I
need or they want way
Rich Shepard writes:
> I'm sure many of you have solved this problem in the past and can offer
> solutions that will work for me. The context is a 73-column postgres table
> of data that was originally in an Access .mdb file. A colleague loaded the
> file into Access and wrote a .csv file for me
Jeff Amiel writes:
> It's come time to bite the bullet and convert a half-terraybyte database
> from ASCII to UTF8. Have gone through a bit of effort to track down the
> unclean ascii text and repair it but would like to avoid the outage of a
> many-many hour dump-restore.
Those blog articles of
Arturo Perez writes:
> Is there currently anyway in 9.0 to use FTS to search for words that are
> next to each other?
Oleg and Teodor worked on that at some point and they call it phrase
search. I don't think it's been commited yet, you can see reference
material in their presentation at pgcon
On Sun, Mar 6, 2011 at 5:41 AM, Martijn van Oosterhout wrote:
> If it's really really important there are ways you can use trigger
> tables and summary views to achieve the results you want. Except it's
> expensive and when people are told that all of the sudden the count(*)
> performance isn't so
ray writes:
> I would like to create a table from a CSV file (the first line is
> headers which I want to use as column names) saved from Excel. I have
You have to manually create the table and its columns, as other said.
The tricky part that is hard (or impossible) to automate is deciding
which
Hi all,
I want to construct an "Composite Index Structure" i.e. a combination of
gist and btree.
What i am thinking is that first creating a Rtree structure that is pointing
to another Btree structure.
For example, Suppose i want to find vehicles between 2 to 4 pm on 14/2/2011
on X road.
I am thi
On Sun, 6 Mar 2011, Dimitri Fontaine wrote:
Did you try pgloader yet?
Nope.
I did determine the reasons and fixed them so all rows read into the
table.
Thanks for the suggestion,
Rich
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscrip
Hi all -
wanted to check, if it is possible to recover the database,
if it is deleted using the pgAdmin. I know it is not possible. Just
wondering . We don't have back either :(
Regards
On Sunday, March 06, 2011 4:24:56 pm akp geek wrote:
> Hi all -
>
>wanted to check, if it is possible to recover the database,
> if it is deleted using the pgAdmin. I know it is not possible. Just
> wondering . We don't have back either :(
Just to be sure you actually deleted the
I appreciate all the information
Thank you,
ray
-Original Message-
From: Dimitri Fontaine [mailto:dimi...@2ndquadrant.fr]
Sent: Sunday, March 06, 2011 3:19 PM
To: ray
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] How to Create Table from CSV
ray writes:
> I would like to crea
hbaile...@nyc.rr.com wrote:
Hello,
I have no IT experience and no funding to hire a technical person or
resources to take a training course. Also my friends who have
programming background have not been reliable. I am willing to spend
the necessary months in trying to learn how to use an SQL
28 matches
Mail list logo
