Em 11/01/2010, às 09:04, hubert depesz lubaczewski escreveu:
>> Hi,
>>
>> I have done:
>>
>> # psql -U postgres -p 4000 -l | hexdump -C
>>
>> And got the two databases: http://pastebin.ca/1746711
>>
>> I couldn't find any difference here.
>
> Could you add -qAt to psql options and rerun the
Em 09/01/2010, às 19:40, hubert depesz lubaczewski escreveu:
> On Fri, Jan 08, 2010 at 02:39:03PM -0200, Fernando Morgenstern wrote:
>> postgres=# drop database skynet;
>> ERROR: database "skynet" does not exist
>
> do:
>
> psql -l | hexump -C
&g
Em 08/01/2010, às 15:58, Adrian Klaver escreveu:
>
> Actually what is strange is that your previous listing :
> postgres=# select '"' || datname || '"' from pg_database;
> ?column?
> -
> "template1"
> "template0"
> "t1"
> "skynet"
>
> is not the same as the one above:
>
> post
Em 08/01/2010, às 15:49, Adrian Klaver escreveu:
> On 01/08/2010 08:55 AM, Fernando Morgenstern wrote:
>
>> Hello,
>>
>> Thanks for your quick answers. The extra space is indeed a copy-and-paste
>> issue. Here it is the select that you suggested:
>>
Em 08/01/2010, às 14:48, Tom Lane escreveu:
> Adrian Klaver writes:
>> On 01/08/2010 08:39 AM, Fernando Morgenstern wrote:
>>> Name| Owner | Encoding | Collation |Ctype| Acce
Hello,
I'm running version 8.4.1 and have a table that appears on listing ( when i
run \l ) but i can't drop it. Example:
postgres=# \l
List of databases
Name| Owner | Encoding | Collation |Ctype| Access
privileges
---+
