[GENERAL] different date-time in base and in system

2007-10-12 Thread Alexander Kuprijanov
Hello I see this problem: $ date; echo 'select CURRENT_TIME;' | psql MyBase Fri Oct 12 14:51:10 MSD 2007 timetz 10:51:11.031388+00 (1 row) Can you please help, what I must do to correct it As I understand this is tom

[GENERAL] how to split coordinates from point

2008-10-22 Thread Alexander Kuprijanov
Hi How to get X and Y coordinates from point(X,Y)? I need only X from (X,Y) Thanks in advance -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] dump-restore only one table

2007-05-01 Thread Alexander Kuprijanov
Hello I have a stooped trable... I have equal bases and , and next table on each of them CREATE TABLE ( idstation int4 NOT NULL DEFAULT serial, ru_name varchar, en_name varchar, address varchar, <...other fields...> CONSTRAINT idstation_pkey PRIMARY KEY (idstation), CONSTRAIN

Re: [GENERAL] dump-restore only one table

2007-05-01 Thread Alexander Kuprijanov
On Tuesday 01 May 2007 14:41:38 Richard Huxton wrote: > Alexander Kuprijanov wrote: > > I do: > > == > > pg_dump -d BaseA --port=54321 --host=localhost --table=TableA --data-only > > -F c -v | pg_restore -d > > BaseB --data-only --no-owner --tab

Re: [GENERAL] dump-restore only one table

2007-05-01 Thread Alexander Kuprijanov
On Tuesday 01 May 2007 18:43:37 Tom Lane wrote: > Alexander Kuprijanov <[EMAIL PROTECTED]> writes: > > but pg_restore dont want make its work... > > > > % pg_restore --dbname=BaseB --no-owner --table=TableA -v > > ./idstation

Re: [GENERAL] dump-restore only one table

2007-05-01 Thread Alexander Kuprijanov
On Tuesday 01 May 2007 20:02:55 Tom Lane wrote: > Alexander Kuprijanov <[EMAIL PROTECTED]> writes: > > On Tuesday 01 May 2007 18:43:37 Tom Lane wrote: > >> Works for me. Perhaps your table name is mixed-case and you didn't > >> quote it correctly? Have yo