gettablename('[table]');
Also be aware to switch back when you do the process again, so you dump
the data from the [table]2 to [table].
For my experience this way was faster then dump-truncate-restore on the
table.
Regards,
Aldor
Ilya A. Kovalenko wrote:
> Greetings,
>
> Wha
eds of millions.
Regards,
Aldor
Ilya A. Kovalenko wrote:
> Greetings,
>
> What advantages I lose, when using dump-truncate-restore (table
> or whole DB) instead of performing VACUUM FULL ?
> In both cases I have no access to data, but first is much faster
> (by subjec
uot;//" is typee
Cédric Buschini wrote:
> Aldor wrote:
>
>> What is the name of the table you want to dump?
>>
>>
> I kown I can use pg_dump to perform that "back up" but I wanted to test
> performences.
>
> The table is carax_exec
>
&g
Hi,
I want to get out a string only with characters A-Za-z.
I tried really a lot of things with substring and read many POSIX docs,
I'm also familiar with the Perl RegEx but right now, I'm giving up... ;-(
Any idea how to do this in Postgres with POSIX Regex?
Regar
1st
---
if you use php you can use the function:
"pg_escape_bytea()"
when you want to retrieve the data from db you have to use:
"pg_unescape_bytea()"
for unescaping it
see the php documentation on this function for more information
2nd
---
if you want to insert biiig data volumes try eith
