On 2022-11-03 15:43, Adrian Klaver wrote:
On 11/3/22 07:28, Post Gresql wrote:
Hello
I first successfully ran
pg_dump -U postgres -b -E UTF8 -f my_dump --format=custom -n my_schema
--no-owner -v my_db
but then
pg_restore --single-transaction -v -U postgres -O -e -d my_other_db my_dump
On 2022-11-03 15:57, Adrian Klaver wrote:
On 11/3/22 07:45, Ron wrote:
On 11/3/22 09:28, Post Gresql wrote:
Hello
I first successfully ran
pg_dump -U postgres -b -E UTF8 -f my_dump --format=custom -n my_schema
--no-owner -v my_db
What was the *complete* pg_dump command?
I'm goi
Hello
I first successfully ran
pg_dump -U postgres -b -E UTF8 -f my_dump --format=custom -n my_schema
--no-owner -v my_db
but then
pg_restore --single-transaction -v -U postgres -O -e -d my_other_db my_dump
failed with
pg_restore: connecting to database for restore
pg_restore: creating FUNC
On 2020-11-18 17:07, Adrian Klaver wrote:
\d cell_per
Foreign table "public.cell_per"
Column | Type | Collation | Nullable | Default | FDW
options
--+---+---+--+-+-
category | character varyi
On 2020-11-18 04:37, David G. Johnston wrote:
(resending to include the list)
On Tue, Nov 17, 2020 at 3:12 PM Post Gresql <mailto:postgre...@taljaren.se>> wrote:
create type my_type as my_table%rowtype;
This would be redundant with existing behavior - all tables have a
corr
Hello.
It seems that I can not create a type with
create type my_type as my_table%rowtype;
or
create type my_type as my_table.my_column%type;
Correct? It seems to be a feature for plpgsql programing only, right?
But wouldn't that be a good thing to be able to do? Or would it cause
too many
Hi,
Is there chance we will get packages (like those in Oracle) in PostgreSQL?
They are kind of nice to have. The main advantage from my point of view
is the ability to grant execute to a single package to a user and then
they can run all procedures in the package.
