From: | Shane Ambler <pgsql(at)Sheeky(dot)Biz> |
---|---|
To: | Anton Andreev <anton(dot)andreev(at)fmi(dot)uni-sofia(dot)bg> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: How to "use" database? |
Date: | 2008-03-26 16:41:04 |
Message-ID: | 47EA7CA0.6040809@Sheeky.Biz |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Anton Andreev wrote:
> Hi,
>
> Thank you for you detailed answer, but I am exactly in the case when I
> want to paste the script and hit F5 and have both the database and
> tables created.
>
> A problem also comes from the fact that in order to use the query window
> in pgadmin3, you need to select a database. Then when you create a new
> database you can not access it by name cause you receive an error "cross
> database referencing is not allowed".
>
You may be able to get your script to work with pgAdmin's restore option
(which seems to use pg_dump)
Try opening your script using the restore command in pgAdmin (Tools menu).
If it doesn't work, backup from pgadmin as a plain file and compare what
it puts out to what you have done.
--
Shane Ambler
pgSQL (at) Sheeky (dot) Biz
Get Sheeky @ http://Sheeky.Biz
From | Date | Subject | |
---|---|---|---|
Next Message | Joey K. | 2008-03-26 16:43:20 | Fwd: Survey: renaming/removing script binaries (createdb, createuser...) |
Previous Message | björn lundin | 2008-03-26 16:37:44 | Re: Survey: renaming/removing script binaries (createdb, createuser...) |