Hello,
I'm trying to import a text file into a table using the COPY command.
The text file contains four columns: id, col_1, col_2, col_3 (in that order).
My target table only has id and col_1.
From the documentation I assumed that the following statement
copy foo (id, col_1)
from
Craig Ringer wrote on 11.11.2012 11:23:
It seems like you want to be able to say something like this (imaginary)
syntax:
\copy test_copy (id, col1) FROM 'test.csv' CSV COLUMNS(1,2,IGNORE)
or some similar way to provide a column mapping from the CSV columns to
the output of the COPY command.
Jayadevan M, 25.10.2012 05:15:
There are tools which generate data, but most of them seem to
generate junk data.
Have a look a Benerator. It can create quite reasonable test data (e.g. valid addresses,
real looking names and so on).
It has a bit steep learning curve, but I'm quite happy with
Evan D. Hoffman wrote on 11.10.2012 20:54:
Is there any way to disable the guessing of missing columns in a
group-by (the feature added in 9.1)?
Because we have both 9.0 and 9.1 running, and a query that succeeds
under 9.1 was failing under 9.0. Can I assume the answer then is
no?
If you
Swayam Prakash Vemuri, 04.10.2012 08:52:
Hi
We have an application which uses postgresql 7.4.5.
Now when we moved to Java 1.6, we are seeing lots of jdbc driver related
compilation issues like shown at end of this email.
Not only are you using an outdated (and unsupported) PostgreSQL
John R Pierce, 05.10.2012 08:34:
You are also moving to a Java version that is soon to be
de-supported.
Java is supported? only if you mean the non-stop stream of updates
brought on by web exploit exposures.
Yes it is. In a similar way as PostgreSQL is supported.
if you're using Java as
John R Pierce, 05.10.2012 08:34:
On 10/04/12 11:21 PM, Thomas Kellerer wrote:
You are also moving to a Java version that is soon to be de-supported.
Java is supported?
Found the link as well:
http://www.oracle.com/technetwork/java/javase/eol-135779.html
Quote: After February 2013, Oracle
Boriss Redkins, 02.10.2012 10:42:
I've got postgreSQL 8.4 and 91. installed on my Windows 7 machine. 9.1 version
starts just fine. But when trying to start 8.4 with:
Services
Microsoft Corporation
Version: 6.1.7600.16385
it does not start and no logs are produced.
When starting in console:
Scot Kreienkamp wrote on 25.09.2012 22:35:
The application is using a pooler and generally runs around 100
connections, but I've seen it as high as 200 during the day for
normal use. It's on a large server; 64 cores total and about 500
gigs of memory. That's one of the reasons I left it at 512
Adam Mackler, 17.09.2012 11:06:
I have the feeling the answer is no, but I would like an
authoritative answer before I give up.
My plan was to have two schemas: one for the live data, and one for
staging, training, and testing. Both schemas would have
identically-named tables. I wanted to
Bret Stern wrote on 08.09.2012 22:18:
A better place for validation is in the front-end, before
adding/attempting to add data to the db (my opinion).
Nice to see there are always other ways though.
I beg to differ: every validation that can be enforced by declarative
constraints *should* be
Martijn van Oosterhout, 28.08.2012 10:02:
I'm not sure how oracle avoids the same issues:
- The index has no visibility information, so you can't tell if an
index entry refers to a row you can actually see in your session.
The visibility map might help here in the future.
In Oracle an
Craig Ringer, 28.08.2012 15:04:
In Oracle an index (entry) has the information about transactional visibility.
Wow. Doesn't that mean that indexes are insanely expensive to update,
since each index (and possibly also the table its self) needs
updating?
No, I don't think so.
It's the same
Tom Lane, 28.08.2012 16:30:
In Oracle an index (entry) has the information about transactional visibility.
You sure about that?
Yes, although technically it's not the index *entry*, but the index *block*.
But the result is the same thing.
The visibility information is stored on data block
Hi,
I'm playing around with 9.2 beta4 and was looking into the new Index Only Scan
feature.
I was a bit surprised that a count(*) query does not use an index.
Not even a count(col) where col is the PK of the table.
Is that intended? If so, why is that the case?
I would have thought that this
Tom Lane wrote on 26.08.2012 16:31:
Thomas Kellerer spam_ea...@gmx.net writes:
I'm playing around with 9.2 beta4 and was looking into the new Index Only Scan
feature.
I was a bit surprised that a count(*) query does not use an index.
Works for me. However, the cost estimate
Jeff Janes wrote on 26.08.2012 20:45:
The seq scan is estimated to use sequential reads, while the
index-only scan is estimated to use random reads (because the index is
scanned in logical order, not physical order).
If you set random_page_cost equal to seq_page_cost, that would
artificially
Jeff Janes wrote on 26.08.2012 22:26:
The seq scan is estimated to use sequential reads, while the
index-only scan is estimated to use random reads (because the index is
scanned in logical order, not physical order).
Sounds like scanning the index in physical order would be an enhancement.
Chris Travers, 23.08.2012 05:22:
The fact that this allows you to create essentially derived values
from groups of re-used columns is itself remarkable and can be used
to implement path traversal etc. which is not directly supported in
PostgreSQL in the sense that it is in Oracle or DB2.
What
Mike Christensen, 23.08.2012 02:41:
Oh, also if anyone knows of a way to export an Access database to
Postgres, that might be helpful. I don't have a copy of Access.
If you have a Windows box, you can try SQL Workbench/J. Even though it is a
Java application it can connect to an Access
Craig Ringer wrote on 04.08.2012 03:39:
Hi all
On Stack Overflow I was following the efforts of a user who was
unable to install Pg.
http://stackoverflow.com/questions/11656410/postgresql-installation-issue#comment15679519_11656410
They've just come back to let me know they found a solution
Manoj Agarwal wrote on 26.07.2012 12:39:
Hi,
I have two virtual machines with two different versions of
Postgresql. One machine contains Postgres 7.4.19 and another has
Postgres 8.4.3. I also have other instances of these two virtual
machines. I need to transfer the database from one machine
jtkells, 25.07.2012 03:43:
Thanks much for your reply, that does the trick quite nicely. But, I just
came to the realization that this only works if your are running the
client and the file both resides on the database server. I thought that
I would be able to do this from a remote server
Chris Angelico wrote on 20.07.2012 18:25:
I don't know how hard it'd be to make it work on Postgres, but here's
an epic piece of SQL awesomeness:
http://thedailywtf.com/Articles/Stupid-Coding-Tricks-The-TSQL-Madlebrot.aspx
That has already been done - and much cleaner I think ;)
Sam Z J wrote on 20.06.2012 19:10:
Hi all
I'm curious how is wildcards at both ends implemented, e.g. LIKE '%str%'
How efficient is it if that's the only search criteria against a large table?
how much does indexing the column help and roughly how much more space is
needed for the index?
if
Alan Hodgson wrote on 20.06.2012 19:39:
I'm curious how is wildcards at both ends implemented, e.g. LIKE '%str%'
How efficient is it if that's the only search criteria against a large
table? how much does indexing the column help and roughly how much more
space is needed for the index?
haman...@t-online.de, 14.06.2012 10:17:
Hi,
I have a column declared as array of text. I can get a single backslash into
one of the array elements by
update ... set mycol[1] = E'blah \\here'
If I try to update the whole array
update ... set mycol = E'{blah \\here}'
the backslash is missing. I
Chris Travers, 13.06.2012 09:16:
If this ever changes, I would certainly hope that the SQL language
functions would first be given named argument support.
This is coming in 9.2
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
Rich Shepard wrote on 13.06.2012 00:17:
One table, waterchem, with primary key 'site' has columns easting and
northing with no values in them. A second table, sites, with primary key
'name' has values for easting and northing for each row. I want to update
waterchem with the easting and
Magruder, Ryan S. wrote on 11.06.2012 16:55:
When attempting to download and install Postgres on my computer for
work, it prompted me to create a password. Upon trying many different
combinations I could not get one to work. An error message stated
that the password I entered did not meet the
utsav, 04.06.2012 07:00:
No.. in this we have to define domain and than used it . Our requirenment is
like application pass the array of integer and that we have to use in
PostgreSQL functions.
You can pass an array directly. There is no need to define an array type in
PostgreSQL
--
Sent
Bryan Montgomery wrote on 01.06.2012 17:28:
So we've been reviewing our processes and working on improving them. One area
we've been lacking is a procedure to version control our database functions,
table changes, static data etc.
I'm curious how others do it. Ideally, we want it to be part of
Aleksey Tsalolikhin wrote on 06.05.2012 19:24:
Situation: When a system administrator or database administrator looks at
a gnarly SQL query chewing up system resources, there is no way to tell
by looking at the query server-side which application it came from, what its
purpose is, and who the
Rafal Pietrak, 24.04.2012 09:02:
Hi all,
Recently I have fell onto a multicolumn update problem, earlier
discussed here:
http://postgresql.1045698.n5.nabble.com/UPDATE-of-several-columns-using-SELECT-statement-td1916045.html
But in my case, subselect does not help, since in my case, new
Chris Angelico wrote on 12.04.2012 17:10:
patchlevel = query(select patchlevel from config)
switch (patchlevel)
{
default: print(Unknown patch level!); break;
case 1:
print(20120216: Adding Foobar columns to Quux)
query(ALTER TABLE Quux ADD foo smallint not null default 0, ADD
Welty, Richard wrote on 12.04.2012 16:57:
can anyone recommend an open source tool for diffing schemas?
(it should go without saying that i'm looking for ddl to update
production and QA DBs from development DBs, but i'll say it, just in
case.)
You might want to have a look at SQL Workbench/J.
Jon Nelson wrote on 04.04.2012 15:50:
I need to have something table-like from the client's perspective for
a bunch of reasons.
For now, assume that I want to keep using the view and that I'd like
to find better ways to address my concerns.
What about a set-returning function that builds the
Jon Nelson wrote on 04.04.2012 19:47:
What about a set-returning function that builds the query dynamically and
wrapping that into a view?
That way the view would never change and client would still have the
perspective of a view/table
Your function could pick up the changes automatically e.g.
Jon Nelson wrote on 03.04.2012 19:01:
I also update this view with CREATE OR REPLACE VIEW every 15-30 minutes
That is a highly questionable approach.
What real problem are you trying to solve with that?
Maybe there is a better solution that does not require changing the view.
--
Sent via
Jon Nelson wrote on 03.04.2012 20:41:
Close, but not quite. It's not rotation but every N minutes a
newly-built table appears. I'd like that table to appear as part of
the view as soon as possible.
Can't you use table inheritance for that?
--
Sent via pgsql-general mailing list
Jonathan Bartlett wrote on 29.03.2012 22:39:
Your suggestion gives me an idea, and I'd like your opinion since I haven't
done much with schemas.
(1) Separate the datasets into different schemas
(2) Use different schema names for different static data releases
(3) For the *company*, we can use
niss...@wp.pl, 27.03.2012 10:46:
Hi,
I need to install PostgreSQL 9 but in silence mode (like in MSI Installer
for Postgres 8.3). Is it possible with PostgreSQL 9.0 or higher?
Why not use the binary ZIP distribution?
Steps for installing are then:
1) Unzip the archive
2) Run initdb
3)
AI Rumman wrote on 24.03.2012 09:06:
I am using Postgresql 9.1.0.
I found that following GROUP BY query works in my DB :-
\d t1
Table public.t1
Column | Type | Modifiers
+-+---
i | integer | not null
nam| text|
Indexes:
t1_pkey PRIMARY
Marti Raudsepp, 21.03.2012 12:35:
E.g. VACUUM/ANALYZE needed to be ran manually and it used to take an
*exclusive* lock on tables, for longish periods, preventing any
queries! Failure to vacuum would cause the files to bloat without
limit and slow down your queries gradually. In the worst case,
Stefan Keller, 08.03.2012 20:40:
Hi
I do have a student who is interested in participating at the Google
Summer of Code (GSoC) 2012
Now I have the burden to look for a cool project... Any ideas?
-Stefan
What about an extension to the CREATE TRIGGER syntax that combines trigger
definition
Twaha Daudi wrote on 10.03.2012 10:32:
Hello all, Good day. I have installed postgres 8.4 on ubuntu 11.10
desktop.My interest is to test three web-based application.One is
drupal7.the other two still working on it.There should be possibility
of data transaction between them.The two web based
Andre Lopes, 21.02.2012 16:11:
Hi all,
I need to create a table to store Twitter accounts information,
Facebook and other social networks details for API login. I need to
know if it is possible to store the account details(account_details
field) in a field that contains something like an array.
Misa Simic, 06.02.2012 10:35:
Hi Bob,
I guess with overwrite the table you mean to fill some columns with your
values in trigger...
If that is the case, in docs is example:
http://www.postgresql.org/docs/8.1/static/plpgsql-trigger.html
Kind Regards,
Please do not link to outdated
Rodrigo E. De León Plicet wrote on 26.01.2012 22:52:
Oracle claims it for releases going back to 7
Not true.
Quote from the Oracle concepts manual:
Multiple-process Oracle (also called multiuser Oracle) uses several processes to
run different parts of the Oracle Database code and additional
Stefan Keller wrote on 06.01.2012 19:04:
I maintain images (from Webcams). In the Java and Hibernate (JPA) code
I specified a @Lob annotation on class MyData and a attribte/data type
byte[] mydata;. Hibernate then generates two tables in PostgreSQL,
one called MyData with a column mydata of type
Stefan Keller wrote on 08.01.2012 19:13:
I think you are better off using bytea unless you need to access only parts
of the blob regularly.
That's a valid tip. But it's to the current JDBC implementation to
take action because it currently leads to disk space leakage when
using JDBC and
Stefan Keller wrote on 08.01.2012 20:35:
2012/1/8 Thomas Kellererspam_ea...@gmx.net:
What's the reason for you to stick with LargeObjects?
I simply used the @Lob annotation in Hibernate/JPA.
That's all to get a leaking pg_largeobject table.
See http://relation.to/Bloggers/PostgreSQLAndBLOBs,
Tom Lane wrote on 28.12.2011 01:41:
Thomas Kellererspam_ea...@gmx.net writes:
Tom Lane wrote on 27.12.2011 20:22:
More specifically, look to see if the current transaction has assigned
itself a transaction ID. I think the easiest place to see this is in
pg_locks --- it will be holding
Hi,
is there a way I can detect if the current session has any uncommitted changes?
I'm not trying to find uncommitted changes from other sessions (connections)
only for the *current* one.
I thought there was a discussion on the mailing list that involved the txid_XXX
functions, but I
Bill Moran wrote on 27.12.2011 19:37:
is there a way I can detect if the current session has any uncommitted changes?
I'm not trying to find uncommitted changes from other sessions (connections)
only for the *current* one.
I thought there was a discussion on the mailing list that involved the
Tom Lane wrote on 27.12.2011 20:22:
If I'm understanding you correctly, you could just make it check the
transaction status. If there's an active transaction, then there are
uncommitted changes.
Sounds like what I want, but how do I check the transaction status (I'm using
JDBC)
More
Mike Christensen wrote on 27.11.2011 22:18:
I have a table with this layout:
CREATE TABLE Favorites
(
FavoriteId uuid NOT NULL, --Primary key
UserId uuid NOT NULL,
RecipeId uuid NOT NULL,
MenuId uuid
)
I want to create a unique constraint similar to
David Johnston wrote on 27.11.2011 23:18:
Also, the index example above presumes you want RecipeId to be Null-able
as opposed to MenuId as described in your original post.
Well of course that was a typo in my answer, it should have been:
CREATE UNIQUE INDEX Favorites_UniqueFavorite
ON
Mike Blackwell, 21.11.2011 17:50:
I've seen a couple backup scripts that query the metadata to
determine the list of databases to back up. I like this approach,
but have a few databases which don't get backed up for various
reasons, e.g. testing databases which we'd prefer to recreate on the
Ivan Sergio Borgonovo, 16.11.2011 01:01:
test=# begin;
create or replace function process_table (
action TEXT, v_table_name varchar(100)
) RETURNS BOOLEAN
AS $$
DECLARE
BEGIN
return true;
END;
$$ LANGUAGE plpgsql;
drop function process_table (
action TEXT,
Tarlika Elisabeth Schmitz, 10.11.2011 00:52:
I would like to implement the equivalent of count (DISTINCT field) OVER ():
SELECT
id, name, similarity(name, 'Tooneyvara') as delta,
count (id) OVER() AS cnt
FROM vtown
WHERE
similarity(name, 'Tooneyvara') 0.1
ORDER BY delta
Tarlika Elisabeth Schmitz, 10.11.2011 11:24:
SELECT id,
name,
delta,
sum(case when rn = 1 then rn else null end) over() as
distinct_id_count
FROM (
SELECT
id, name, similarity(name, 'Tooneyvara') as delta,
row_number() OVER(partition by id) AS rn
Henry Drexler, 10.11.2011 14:22:
I am thinking there is a better/simpler way, though this is what I have working:
(postgres 9.1)
I would like to have the list of colors for each type of clothing to be comma
seperated in the end result.
like this:
typeorganized_by_type
pants
Hello,
I just noticed that Postgres allows the following syntax:
create table foo
(
id integer constraint id_default_value default 42
);
But as far as I can tell the constraint id_default_value part seems to be
only syntactical sugar as this is stored nowhere. At least I couldn't find it
Thom Brown, 28.10.2011 10:10:
On 28 October 2011 08:29, Thomas Kellererspam_ea...@gmx.net wrote:
Hello,
I just noticed that Postgres allows the following syntax:
create table foo
(
id integer constraint id_default_value default 42
);
But as far as I can tell the constraint
Robert Buckley, 28.10.2011 12:49:
according to this article
http://www.informit.com/articles/article.aspx?p=409471, the naming of
tables, and fields is restricted to 63 characters and must start with
an underscore or letter. Nothing is however said about in which
character set.
Am I allowed to
Tom Lane wrote on 28.10.2011 16:21:
I just noticed that Postgres allows the following syntax:
create table foo
(
id integer constraint id_default_value default 42
);
I'm wondering why this doesn't throw an error then.
It's an implementation artifact --- our grammar regards everything after
Mark Cave-Ayland, 25.10.2011 12:51:
As Robert has suggested, you have misunderstood the GPL license - if
you make changes to the *PostGIS* source code AND you distribute the
modified code to your customer (rather than offering a managed
service), you would need to make the changes available to
Eduardo Morras, 21.10.2011 20:53:
Now PostGIS is licensed under the GPL and I wonder if we can use it
in a commercial (customer specific) project then. The source code
will not be made open source, but of course the customer will get
the source code.
Is it still OK to use the GPL licensed
Pavel Stehule wrote on 24.10.2011 12:19:
there is not clean who is customer and what is one unit. If you
distribute PostGIS inside your application as one unit to customer,
then your application should to use GPL.
So if we only distribute our application and require the customer to install
Tomas Vondra wrote on 24.10.2011 20:11:
On 24 Říjen 2011, 19:44, Thomas Kellerer wrote:
Pavel Stehule wrote on 24.10.2011 12:19:
there is not clean who is customer and what is one unit. If you
distribute PostGIS inside your application as one unit to customer,
then your application should
Tom Lane wrote on 22.10.2011 05:24:
I'm thinking there is something you haven't told us about that creates a
great deal of overhead for updates on this table. Lots and lots o'
indexes? Lots and lots o' foreign key references?
Why would an add column need to check foreign key references?
--
Hello,
we are using PostgreSQL in our projects and would like to integrate PostGIS as
well.
Now PostGIS is licensed under the GPL and I wonder if we can use it in a
commercial (customer specific) project then.
The source code will not be made open source, but of course the customer will
get
I have to share this, a statement that is finished before I even run it ;)
Limit (cost=0.00..527.34 rows=20 width=4) (actual time=0.046..-2.436 rows=20
loops=1)
Output: id, (count(*))
Buffers: shared hit=191
- GroupAggregate (cost=0.00..12403455.78 rows=470416 width=4) (actual
Bruce Momjian, 06.10.2011 02:15:
I now got the same error (alas with a different relation id) while
migrating a completely different data directory.
Anything I can do to help find the reason for this problem (or bug?)
Unfortuantely the data contains some confidential information so I
cannot
Rich Shepard, 06.10.2011 15:13:
I was unaware of the windows functions. I see the document page for 9.0.5
so I'll carefully read that and upgrade from 9.0.4 (which may also have this
function; I'll check).
Windowing functions are available since 8.4
--
Sent via pgsql-general mailing list
Dave Page wrote on 03.10.2011 10:11:
Karl; can you please provide precise details of your Windows version,
and anything unusual about your disk configuration? I know this
doesn't happen on any of the installations of Windows 7 that we use
for testing (which tend to be the MSDN builds, running on
Jeff Adams wrote on 01.10.2011 23:30:
Greetings,
I have a large table (~19 million records). Records contains a field
identifying a vessel and a field containing an time (epoch). Using the
current rows vessel and time values, I need to be able to find the next
lowest time value for the vessel
Thomas Kellerer, 17.09.2011 12:32:
I was trying to upgrade my Postgres 9.0 installation using pg_upgrade. Running
it first with --check revealed no problems.
The when I did the actual migration, the following happened:
Mismatch of relation id: database dellstore, old relid 83613, new relid
Craig Ringer, 22.09.2011 08:34:
- You don't see materialized views without selective updating (fast
refresh) as useful. [I disagree, though I can see how it wouldn't be
very useful for the particular use case you're facing.]
One thing that is often overlooked and that I find most useful is the
Martín Marqués, 21.09.2011 14:56:
I was makeing an SQL function and got an error which on a sintax that
I thouhgt would work:
CREATE OR REPLACE FUNCTION dicInsertarPalabra(p TEXT)
RETURNS INT AS $body$
INSERT INTO public.diccionario (palabra) VALUES (quote_literal(p));
SELECT
Craig Ringer, 17.09.2011 02:28:
On 09/17/2011 05:47 AM, Stefan Keller wrote:
A (read-only) view should behave like a table, right?
CREATE INDEX t1_idx ON t1 (rem);
ERROR: »v1« not a table
SQL state: 42809
= Why should'nt it be possible to create indexes on views in PG?
It's not so much
Hi,
I was trying to upgrade my Postgres 9.0 installation using pg_upgrade. Running
it first with --check revealed no problems.
The when I did the actual migration, the following happened:
=== start console output
Performing Consistency Checks
Craig Ringer, 16.09.2011 05:02:
On 15/09/2011 4:18 PM, Thomas Kellerer wrote:
I ran another install and monitored what the process was doing and
it *is* recursively touching all files on my harddisk when
icacls C:\ /grant tkellerer:RX
is called. Even without the /t switch.
That's a worry
Brar Piening, 14.09.2011 21:49:
Thomas Kellerer wrote:
So I killed the iacls.exe and the script proceeded, just to hang at
the next call to icacls.exe when it tried to set the privileges on
the directory for the postgres user despite the fact that that user
already was the owner and had full
Craig Ringer, 14.09.2011 06:20:
As Dave noted, it's a non-recursive grant. It isn't changing the
permissions for C:\ and everything under it. It's only changing the
permissions for C:\ its self. It's then stepping down the path of
parents down to the datadir and doing the same thing to make sure
Craig Ringer, 14.09.2011 06:20:
I forwarded your message to Dave Page in case the EDB folks needed to
look into this. He commented that:
Aside from the fact that icacls is hanging for reasons unknown, it
appears to be doing what it is designed to do - it traverses up the
path from the data
Merlin Moncure, 12.09.2011 21:28:
With the second attempt, the installer again hang during initdb. Checking
the state using ProcessExplorer I could see that the installer script was
waiting for icacls.exe to set permissions for the user currently running the
installer. It was running [icacls.exe
Hi,
I tried to install 9.1 on a Windows7 64bit machine but the installation hangs
during the initdb process.
Looking at the taskmanager I could see that the installer script was waiting
for icacls.exe to complete setting the approriate permissions on the data
directory.
As I know that
Pau Marc Muñoz Torres, 05.09.2011 11:38:
Hi follk
i trying to performe a conditional insert into a table, indeed, what i'm
trying to do is not insert a record into the table if that record exist
googleling i found something like
insert into XX values (1,2,3) where not exist (select
Adarsh Sharma, 31.08.2011 13:54:
Dear all,
Is there any open source ERD Tool for Postgresql Database.
I find some paid tools but looking for free tools.
Have a look at Power*Architect: http://www.sqlpower.ca/page/architect
It's not perfect but it's quite OK.
As it is a multi-DBMS tool it
salah jubeh, 26.07.2011 19:02:
Hello,
suppose the following scenario
the car speed is 240
the car has an airbag
Here the first value is integer and the second value is boolean. Consider that
I have this table structure
feature (feature id feature name)
car (car id, )
car_feature (car
Durumdara, 22.06.2011 12:35:
Hi!
I have 3 tables. I want to run a query that collect some data from
them, and join into one result table.
I show a little example, how to do this in another DB with script:
with tmp_a as (
select id, name, sum(cost) cost
from items
...
),
temp_b as (
Chrishelring wrote on 10.06.2011 22:45:
HI all,
below is the view i´ve tried to create on a table. The purpose was to do
some math on one of the columns (retning). The column is a double precision
number. The result is that the function is not recognized (ERROR: function
to_number(double
Seb wrote on 29.05.2011 23:04:
Hi,
I've been scouring the system tables for a way to return a list of
fields across all tables of a database. I see that pg_attribute is the
one to query here, but I'm not sure how to rule out system fields.
Thanks in advance for any pointers.
Hi,
I'd like to suggest a little enhancement to the documentation chapter about
file-system backup
http://www.postgresql.org/docs/current/static/backup-file.html
As I regularly see people copying files between different operating systems, I
think it would be a good idea to add a third
Hi,
while going through the 9.1 new features, I think I have discovered an error in
the manual regarding the CREATE TABLE command.
It says:
CREATE [ [ GLOBAL | LOCAL ] { TEMPORARY | TEMP } | UNLOGGED ] TABLE [ IF NOT
EXISTS ] table_name ( [
{ column_name data_type [ COLLATE collation ] [
Thom Brown wrote on 07.05.2011 16:28:
while going through the 9.1 new features, I think I have discovered an error
in the manual regarding the CREATE TABLE command.
The DEFAULT declaration was moved into the column_constraint section.
Ah thanks, didn't see that (and I wouldn't expect the
hirenlad, 27.04.2011 09:47:
Hiii
Hey i m using postgresql 8.4. now i m install postgresql8.4 silently
and it work properly, no issue during this process. Now problem is i want to
create one database automatically after install postgresql 8.4.
Can u plz inform me is it possible ? and if
Alban Hertroys wrote on 03.04.2011 11:31:
On 3 Apr 2011, at 11:22, Alban Hertroys wrote:
Oracle and SQL server don't suffer from this because they do not
handle DDL statements transactionally (I could be mistaken about
SQL server, I don't know it all that well).
I forgot to mention, if you
301 - 400 of 803 matches
Mail list logo